-
Title
Reorg created stats when it should not have -
Description
I've ran a reorg on a table last weekend in production, and the primary index has no statistics by design. However, when the reorg had finished, they found that statistics has been created.
-
Resolution
Starting in Oracle 10.1, The create index statement includes COMPUTE STATISTICS by default.. There is no way to prevent Oracle from automatically gathering statistics when index is created.
Quote from the Oracle manual:
http://download.oracle.com/docs/cd/B14117_01/server.101/b10759/statements_5010.htm#sthref4857
COMPUTE STATISTICS:
In earlier releases, you could use this clause to start or stop the collection of statistics on an index. This clause has been deprecated. Oracle Database now automatically collects statistics during index creation and rebuild. This clause is supported for backward compatibility and will not cause errors.