Re: Can somone optimize this Query?

Try create an index on last_name, first_name.

Dowson

vlee_at_jps.net wrote:

> Can anyone optimize this query? It runs really slow.
> SELECT DISTINCT p.personid, p.first_name, p.last_name, p.username,
> p.address1, p.address2, p.city, p.state, p.zip, p.company_name,
> p.phone1, p.fax, p.ref_personid, p2.viewable, nvl((p2.last_modified -
> p.last_modified), 0) as difference FROM person p, person p2 WHERE
> p.ref_personid = p2.personid(+) AND p.ownerid = 25971 ORDER BY 3 ,
> p.last_name, p.first_name
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Tue Oct 12 1999 - 19:13:23 CDT