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 Mon Oct 11 1999 - 21:59:35 CDT
