Tune SQL query

From: <weijendavid_at_my-deja.com>
Date: Fri, 10 Dec 1999 21:02:09 GMT
Message-ID: <82rpoe$g3p$1@nnrp1.deja.com>

Hi, all

Does anybody know how to tune the query below so it doesn't take "Forever" to run, yes, I mean forever...since it never return. Here is the query:

---

delete from caritemoption o where o.caritemid in   (select ci.caritemid from caritem ci, car c    where ci.carid = c.carid
   and upper(c.first_name) = 'xxx'
   or upper(c.last_name) = 'yyyy');

---

There are so many methods introduced in the book but it just makes things more confusing. Please help.

Thank you.

David.

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Dec 10 1999 - 15:02:09 CST