Re: By default, LOB store in line or out of line?
- From: Yong Huang <yong321@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Tue, 24 Apr 2012 11:24:30 -0700 (PDT)
(Hijacking this thread!)
I always tell developers to not use certain data types unless it's absolutely
needed. They like to use CLOB even if the likelihood the text will exceed 4000
chars is almost zero. Some like to use CHAR thinking it's faster and more
space-efficient than VARCAHR2. Wrong data types add unnecesary burden on DBAs.
Yong Huang
--
//www.freelists.org/webpage/oracle-l
Other related posts:
- » By default, LOB store in line or out of line?- Leyi Kamus Zhang
- » Re: By default, LOB store in line or out of line?- du shenglin
- » Re: By default, LOB store in line or out of line?- louis
- » Re: By default, LOB store in line or out of line?- Leyi Kamus Zhang
- » Re: By default, LOB store in line or out of line?- Tanel Poder
- » Re: By default, LOB store in line or out of line?- Tanel Poder
- » Re: By default, LOB store in line or out of line?- fairlie rego
- » Re: By default, LOB store in line or out of line?- Leyi Kamus Zhang
- » Re: By default, LOB store in line or out of line?- du shenglin
- » Re: By default, LOB store in line or out of line? - Yong Huang