review sql querry

[Guest]

hi I use in my application a following querry:

UPDATE tbInvoice SET inPrinted=1
WHERE delID = ANY (SELECT deID from q_Deliveries
WHERE deDate>= #09/13/2006#
AND deDate <= #09/13/2006#)

This querry marks all invoices as Printed (tbInvoice.inPrinted =1 ) within a
range of date which comes from a form. The querry works fine, but is quite
slow. Is there any other way how to replace ANY in the querry?

thanks

 

[John Spencer]

Try:

UPDATE tbInvoice
SET inPrinted=1
WHERE delID IN (SELECT deID from q_Deliveries
WHERE deDate>= #09/13/2006#
AND deDate <= #09/13/2006#)

If performance is slow, I would also set indexes on delID, deID, and deDate.

q_Deliveries could also be what is causing the slowdown, but you haven't
posted that SQL.

 

[Guest]

John, I have already tried replace ANY with IN, but it did not work. Anyway,
I think you are right the issue does not seem to be in this particular
querry, but with the subquerry q_Deliveries which is quite complex. I will
try to simplify it.

thanks