Re: Performance and datatypes

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Tue, 27 Jul 1999 21:46:14 +0800
Message-ID: <379DB826.7B5C@yahoo.com>

skips_at_my-deja.com wrote:
>
> Are there any ramifications for using the varchar
> datatype with regards to performance, as opposed
> to using the char datatype?
>
> I with other databases this can be an issue but I
> have not been able to find any documentation on
> Oracle that relates to this subject.
>
> Thanks
>
> Skip
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.

Whilst char will occupy the maximum length specified and varchar2 will not...they are actually both stored in the same fashion within the database..ie length and content. So the datatype is not as important as the size of the data you are planning to store...

varchar2 will possibly let you pack more info into a row, but char will avoid the likelihood of chained rows...

HTH
--

---

Connor McDonald
"These views mine, no-one elses etc etc" connor_mcdonald_at_yahoo.com

"Some days you're the pigeon, and some days you're the statue." Received on Tue Jul 27 1999 - 08:46:14 CDT