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:22:06 -0700

Given those counts, is there a histogram on external_accession.SEQTABLEID ?

At 10:44 AM 3/1/2004, you wrote: 

The rowcount are not exact the same, but close. The 9i dataset is loaded
using the dump that was a few weeks old. And I ran
DBMS_STATS.GATHER_TABLE_STATS after the loading.

Guang


-- from 8173:
MT@atlas-SQL> select count(*) from mt.External_accession;

  COUNT(*)
----------
  38102138

MT@atlas-SQL> select count(*) from mt.identifier;

  COUNT(*)
----------
    127836


-- from 9204:

SQL> select count(*) from mt.External_accession;

  COUNT(*)
----------
  36907691

SQL> select count(*) from mt.identifier;

  COUNT(*)
----------
    127612

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 //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 03-2004