Table1.TextField....Teable2.TextField etc.
Bryan Stevenson B.Comm.
VP & Director of E-Commerce Development
Electric Edge Systems Group Inc.
t. 250.920.8830
e. [EMAIL PROTECTED]
---------------------------------------------------------
Macromedia Associate Partner
www.macromedia.com
---------------------------------------------------------
Vancouver Island ColdFusion Users Group
Founder & Director
www.cfug-vancouverisland.com
----- Original Message -----
From: Scott Weikert
To: SQL
Sent: Friday, May 14, 2004 1:13 PM
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]
