General information
Category:
Coding, syntax & commands
>>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
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only