Re: Why this query is SO slow?

Try,

select id from phase
where NOT EXISTS ( select null
from phase2 where phase2.id = pahse.id)

Oracle will use index on phase2.id, if there was the index. Received on Sun Apr 14 2002 - 21:57:09 CDT