Now that I finally have all of our databases upgraded to 8.1.7 I am taking some time
to look at our method of gathering statistics for CBO. It looks like I should move
towards using DBMS_STATS to gather statistics, but I may want to use ANALYZE if I need
to gather stats on individual columns
I would highly recommend that you move to DBMS_STATS if you are running at
least 8.1.6.3 -- especially if you are estimating statistics.
The reason is that DBMS_STATS generates more and better statistics than
analyze. I've seen queries go from hours to minutes just by changing from
ANALYZE to
Jay,
I have switched to DBMS_STATS for quite some now. Most databases are
8.1.7.x.
I have not had any problems running DBMS_STATS. Or from the generated
stats.
- Kirti
-Original Message-
Sent: Thursday, January 10, 2002 9:31 AM
To: Multiple recipients of list ORACLE-L
Now that I
Thanks for the reply.
[EMAIL PROTECTED] 01/10/02 11:11AM
Jay,
I have switched to DBMS_STATS for quite some now. Most databases are
8.1.7.x.
I have not had any problems running DBMS_STATS. Or from the generated
stats.
- Kirti
-Original Message-
Sent: Thursday, January 10, 2002
