| overhead with varchar2? [message #176726] |
Fri, 09 June 2006 05:40  |
jerryhaley
Messages: 2
Registered: June 2006
Location: PA
|
Junior Member |
|
|
I realize that varchar2 will use less disk space when the data is smaller than the defined maximum size. However does a varchar2 column have other overhead that you wouldn't have with a character column? Row movement? Archive logs being larger? Doesn't a varchar2 have extra overhead to store the size? It would be great if you could point me to an Oracle document that answers these questions. Thank you.
|
|
|
|
| Re: overhead with varchar2? [message #176729 is a reply to message #176726] |
Fri, 09 June 2006 05:50  |
JSI2001
Messages: 1016
Registered: March 2005
Location: Scotland
|
Senior Member |
|
|
Have you read a document that makes you think that this would be the case?. Did you read the link that LittleFoot supplied you? Did you notice that both the Varchar2 and char datatypes BOTH store the size.
You should really have continued this thread with the one that you were currently on as it is effectively part of the same question.
Jim
|
|
|
|
| Re: overhead with varchar2? [message #176766 is a reply to message #176726] |
Fri, 09 June 2006 08:44 |
smartin
Messages: 1803
Registered: March 2005
Location: Jacksonville, Florida
|
Senior Member |
|
|
|
Also you could do a test, create two tables, one with varchar2(1) and one with char(1), fill them both up with data, and measure the size. Then do the same thing for size 100. While you are at it, do another one with numbers.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
