Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> CHAR vs VARCHAR(2) - Performance
From reading several of the threads here, it is my understanding that
(beyond simple disk i/o) there is no real performance advantage of CHAR
of VARCHAR(2). In fact, indexes built on VARCHAR(2) fields will likely
perform (albeit marginally) better than those built on CHAR fields.
It appears that the only risk in using VARCHAR(2) fields is a chance of
chaining as dynamically sized VARCHAR data is passed in and out of the
table.
Other than that, CHAR vs VCHAR kind of comes down to a matter of
personal preference.
Does this seem to be accurate?
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Wed Mar 22 2000 - 00:00:00 CST