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.

Report message to a moderator

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.

Report message to a moderator

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

Report message to a moderator

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.

Report message to a moderator

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:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Nov 27 03:23:29 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.