Re: SQL statement performance

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Tue, 15 May 2001 00:49:34 +0200
Message-ID: <tg0o3tgbeveu92@beta-news.demon.nl>

"Guang Mei" <gmei_at_proteome.com> wrote in message news:Z%YL6.625$du2.59978_at_news.shore.net...
> 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.
>
>
>
>

Please refrain from posting to multiple groups as much as possible in order not to waste peoples resources and time. You'r not getting a bigger audience by posting in multiple groups. If you are *really* convinced you should post in multiple groups, please crosspost, so all answers are automatically crossposted to other groups.

Regards,

Sybrand Bakker, Oracle DBA Received on Mon May 14 2001 - 17:49:34 CDT