UPDATE Table2
SET IntegerField = 1
WHERE TextField IN
(SELECT TextField
FROM Table1)
Now on Table2, I've got both the text field and integer field that are being used indexed. In Table1, I've got that text field indexed. Non-unique, non-clustered (SQL Server 7).
The indexing has helped tremendously with other operations, but this multi-table issue is still killing me. Running the query in Query Analyzer, it's at 11min and counting. Both tables have between 410k and 420k records.
What can I do differently that will speed this update up?
--Scott
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
