Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to disable automatic statistics collections on tables

jdiAug 8 2008 — edited Sep 15 2008

Hi

I am using Oracle 10g and we have few tables which are frequently truncated and news rows added to it. Oracle automatically analyzes the table by some means which collects statistics of the table but at the wrong time(when the table is empty). This makes my query to do a full table scan rather using indexes since the statistics was collected when the table was empty.Could any one please let me know how to disable the automatic statistics collection feature of Oracle?

Cheers
Anantha PV

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 13 2008

Added on Aug 8 2008

#general-database-discussions

7 comments

5,233 views