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

Reply via email to