Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> SQL statement performance

SQL statement performance

From: Guang Mei <gmei_at_proteome.com>
Date: Mon, 14 May 2001 18:29:02 -0400
Message-ID: <B_YL6.624$du2.59946@news.shore.net>

Oracle : 8.0.5
Platform : Sun

SQL statement:

select distinct(spid) spid, name, commonname from (

    select distinct queryspid spid from results union     select distinct subjspid spid from results    ) a, species
   where a.spid=species.id ;

Table "Species" only has 33 records, while table "results" has about 8000000 records. There are indexes on queryspid and subjspid.

This query is somehow slow. Is there any "easy" way to speed it up?

Thanks. Received on Mon May 14 2001 - 17:29:02 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US