Home » RDBMS Server » Performance Tuning » Which One is better... VARCHAR or Number
Which One is better... VARCHAR or Number [message #210323] Wed, 20 December 2006 06:38 Go to next message
amit_nanote
Messages: 56
Registered: July 2005
Location: Indore
Member

On the performance issue...
I would like to know that which data type among varchar and number..
Conditions.
Table is having about 10 columns
exepected rows to be populated 10 million.
The column for which I am asking having field width Min=15 and Max=20.
Please suggest.
Thank you.
Re: Which One is better... VARCHAR or Number [message #210328 is a reply to message #210323] Wed, 20 December 2006 06:53 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
Your Datatype should be determined by the data you're storing, and nothing else.
Re: Which One is better... VARCHAR or Number [message #210331 is a reply to message #210328] Wed, 20 December 2006 07:03 Go to previous messageGo to next message
amit_nanote
Messages: 56
Registered: July 2005
Location: Indore
Member

Thank you,
but I am having both option. In that context what are the suggestions. On the performance issue which would be better.

regds
Re: Which One is better... VARCHAR or Number [message #210334 is a reply to message #210331] Wed, 20 December 2006 07:09 Go to previous message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
Is your data going to be entirely numeric, with no requirements for storing leading or trailing 0's?
If so, pick NUMBER or INTEGER.
Otherwise, pick VARCHAR2.
Previous Topic: High activity of "delete from smon_scn_time" in statspack report
Next Topic: Avoiding FTS, Any better Way to write this
Goto Forum:
  


Current Time: Tue Dec 06 04:28:11 CST 2016

Total time taken to generate the page: 0.20433 seconds