🚀 go-pugleaf

Hi all
 I implemented a client solution running om IB 6 opensource, this was years
 ago and the database / table structure is defintely not optimized. In terms 
of
 indices and referential constraints and cascading deletes, I know all of 
this
 stuff now but like I said this was years ago. Anyways I have a query of the 
form
Delete From PaymentsWip Where WipNo in

(select WipNo From InternalInvmaster Where (Cast(inqDate as Date) <= 
'12/31/2001'))

 and its really slow, and I need to have about 10 of these run on separate 
tables,
 I tried to backup and restore and sweep and then ran the query, but that 
only shaved off
 4min on a 20 min query,

the question , should I create an Index on the inqDate fields, and is the 
"in" operator
in the SQL the issue, can I re-wite the query? Also I was running this right 
from the IBConsole.

any suggestions would really be helpful as I need to dump a bunch of data 
monday morning
at the client site?

Thanks All
Jarek Bialik
Britec Software