OOPS, most of my answer was already there, DOH! If you have a primary key on the table:
DELETE ROWS FROM travcard where tableid in + (select distinct tableid from travcard WHERE txdate = .#DATE AND sympt1 IS NULL AND subjx IS NULL) If it is still slow, look for an VERY inefficient index on any column. An index on a column that is mostly one value (NULL?) will slow down a delete to crawl Dennis McGrath ________________________________ From: [email protected] [mailto:[email protected]] On Behalf Of MDRD Sent: Wednesday, July 14, 2010 10:25 AM To: RBASE-L Mailing List Subject: [RBASE-L] - How to make this Delete command faster Hi This command takes too long when we run it from a workstation but I can not think of any way to speed it up. txdate is Indexed symptom is Text 150 no Index we will not search on this column subjx is Varchar no Index and we will not search on this column either DELETE ROWS FROM travcard + WHERE txdate = .#DATE AND sympt1 IS NULL AND subjx IS NULL any suggestions? Thanks Marc
