RE: query slow in 9i, but not slow in 8i

From: Wolfgang Breitling <breitliw_at_centrexcc.com>
Date: Mon, 01 Mar 2004 11:22:06 -0700
Message-Id: <6.0.3.0.2.20040301112121.02b574c8@pop.centrexcc.com>

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_at_atlas-SQL> select count(*) from mt.External_accession;
>
> COUNT(*)
>----------
> 38102138
>
>MT_at_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_at_freelists.org 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
-----------------------------------------------------------------

Received on Mon Mar 01 2004 - 12:23:48 CST