>>Have a group of rows - group1. Have a complete list of all rows - mastergroup. Want to delete from group1 any records that have no match in the mastergroup. Currently i am looping through group1 doing a seek on mastergroup Both group1 and mastergroup are indexed on the same index, and the index matches the seek. Still the mastergorup is large and the sql requires 30 seconds.
>>
>>any ideas on how i can make this more efficient?
>>
>>brenda

>delete from group1 where id_field not in (select id_field from mastergroup)

will look into the delete from. but please read my reply to myself (yes i also talk to myself). i did not see the big picture when i posted the original question.

thanks

brenda