Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Can somone optimize this Query?
This query hangs up our system dramatically. Can anyone tell me a good
way to optimize this?
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:58:40 CDT