Re: By default, LOB store in line or out of line?

(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: