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