General information
Category:
Coding, syntax & commands
Title:
Select sql question
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
Next
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