SQL statement performance

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:30:29 CDT