Re: query plans and clustering

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 1 Sep 2005 12:28:40 -0700
Message-ID: <1125602920.666455.150420@g43g2000cwa.googlegroups.com>

Which specific version of 9 are you on? I hope it is 9.2.0.6

How did you generate the statistics in 9i? If you used dbms_stats verify that you generated 1- generated column level statistics and 2- that you generated the index statistics.

You could try an alter index rebuild with the compute statistics clause to see if that results in a plan change.

You should verity that the index column ordering is the same.

How similiar is the data between the two environments: number of rows, distribution of data values? I would think that all the optimizer statistic values should be close or else this is not a valid comparson.

HTH -- Mark D Powell -- Received on Thu Sep 01 2005 - 14:28:40 CDT