Effect of Blob Column on Statistics

From: DBA Deepak <oracle.tutorials_at_gmail.com>
Date: Tue, 25 Oct 2005 10:30:15 +0530
Message-ID: <75aa80160510242200l2145b90ekad3e14db6773a39f@mail.gmail.com>

Hi All,
Want to know when I collect statistics of a table using DBMS_STATS package, is there any statistics related to BLOB column are gathered? Let's suppose
> I gathered the statistics of a table T1 using DBMS_STATS.
> Added a Blob column to the table T1.

Need I collect statistics for the table T1 again? If I do not, then will it affect the performance?
Please help.

--
Regards,

Deepak
Oracle DBA

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Oct 25 2005 - 00:02:17 CDT