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

Other related posts: