|
[oracle-l]
||
[Date Prev]
[03-2004 Date Index]
[Date Next]
||
[Thread Prev]
[03-2004 Thread Index]
[Thread Next]
RE: query slow in 9i, but not slow in 8i
- From: Wolfgang Breitling <breitliw@xxxxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Mon, 01 Mar 2004 11:05:33 -0700
Piggy-backing on Mark's observation of significantly different cardinality
estimates, can you check specifically for the presence of histograms on the
columns
identifier.seqtabid, identifier.type, and identifier.speciesid
in Oracle 9i
At 10:28 AM 3/1/2004, you wrote:
It would appear from the statistics that there may be a significant
difference in the row counts (cardinality) for the tables involved between
the two instances. If this is true then this is not a fair comparison. To
compare differences in two version of the database the same data really
should be used to generate the statistics and plans.
Wolfgang Breitling
Oracle7, 8, 8i, 9i OCP DBA
Centrex Consulting Corporation
http://www.centrexcc.com
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
|
|
