>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)
Edward Pikman
Independent Consultant