join instead? Or a join to a table that is actually a query?
-Nate
-----Original Message-----
From: Scott Weikert [mailto:[EMAIL PROTECTED]
Sent: Friday, May 14, 2004 3:13 PM
To: SQL
Subject: Big honkin' query gettin' me down!
I've been messing with this particular issue the past couple of days. Other
related queries, I've managed to improve the performance of by leaps and
bounds, but this one still refuses to speed up.
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]
