troubleshooting Question

Query Performance Tuning Tips

Avatar of Starr Duskk
Starr DuskkFlag for United States of America asked on
Microsoft SQL Server 2008
20 Comments6 Solutions273 ViewsLast Modified:
I have a query that takes 1.5 minutes to run (depending on how much data is returned in the query) and I want to performance tune the database for the query.

I have run the "Display Estimated Execution Plan" in SQL Server Management studio and added all the keys suggested.

Now I am adding indexes for any of the fields used in the where clauses and JOIN clauses.

The Client.ClientId is already a primary Index.
There is a PK Key and a PK Index on that field (for all my tables same idea).

But other tables: For instance if it says:
INNER JOIN Client on Client.ClientId = Employee.ClientId

I created an Index on the Employee table, ClientId.

So anything used in a where clause I add another index on that column.

Is that right? Any other ideas?

Kent Olsen
Data Warehouse / Database Architect

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 6 Answers and 20 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 6 Answers and 20 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros