Re: By default, LOB store in line or out of line?
From: Yong Huang <yong321_at_yahoo.com>
Date: Tue, 24 Apr 2012 11:24:30 -0700 (PDT)
Message-ID: <1335291870.40683.YahooMailClassic_at_web181210.mail.ne1.yahoo.com>
(Hijacking this thread!)
Date: Tue, 24 Apr 2012 11:24:30 -0700 (PDT)
Message-ID: <1335291870.40683.YahooMailClassic_at_web181210.mail.ne1.yahoo.com>
(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
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Apr 24 2012 - 13:24:30 CDT