Join 2 large tables take 50-60 seconds

  • Thread starter Thread starter Francis
  • Start date Start date
F

Francis

Hi all

I need to inner join 2 large tables (Millions) of records.
I've introduced indexes on the filter columns and the performance is
improved to 50-60 secs.
However, the CPU utilization of all 4 processors peaked at 100% and remained
constant until the results are returned.

I've tried indexed views and nested selects but none are improving the
performance.

Is there a better way to optimise?

Thanks in advance!

Regards,
Francis
 
Ah, do you really need the product in your application? Does the client
really need to consume the millions of rows? I would use a more focused
product if possible. I would also fire up the Query Analyzer and let SQL
Server Management Studio's tools to figure out if additional indexes would
help. Check out the query plan to see if there's a bottleneck. Of course,
adding RAM often helps--but only to a point.

--
__________________________________________________________________________
William R. Vaughn
President and Founder Beta V Corporation
Author, Mentor, Dad, Grandpa
Microsoft MVP
(425) 556-9205 (Pacific time)
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
____________________________________________________________________________________________
 
Back
Top