Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> dbms_stats set_table_stats, set_index_stats and set_columns_stats
Hi,
I am using dbms_stats to set the stats for partitions just after the creating these partitions. This is done for some reasons I can't change for the moment.
In a 8i db, this works fine.
I'm testing a new 9i db with the same functions, but the optimizer choose very bad plans.
For a query, the results of 10053 event shows (SINGLE TABLE ACCESS PATH)
The best single access cost for table A is 200 (full scan).
The best single access cost for table A is 5 (access to table A using index 2)
The stats listed in the section "BASE STATISTICAL INFORMATION" of the event trace are the same in 8i and 9i.
Any idea ?
Thanks Received on Tue Nov 18 2003 - 16:04:15 CST