又一个WordPress站点

标签归档：all_tab_statistics

in 10.2, Oracle Database now automatically collects statistics during index creation and rebuild

COMPUTE STATISTICSIn 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.

but this is not true when the table statistics is lock, the index statistics can’t be gather until the table staticstics is unlocked