Aug 21, 2008

locked statistics

you can lock statistics. I'm guessing this means that the stats for this table will never change (until at least you lock them).

to lock statistics try:

dbms_stats.lock_table_stats(owner, tablename);

there should be additional parameters to lock column and index statistics as well.

Use the dba_tab_statistics view to verify what tables have been locked.