September 17, 2007 at 1:39 pm
Hi all...not sure if this is the correct forum or if it should have been in Performance Tuning...
My question is two fold. I have been given the project of optimizing a process which was poorly written and is now performing very badly as a result. I am 2/3's of the way done when I unearthed a doozy of a query that was basically two views joined together.
Once I got the original query correct I went into the execution plan and have one table that has 1.6 million rows which is getting an Clustered Index Scan...
I have attempted without success in creating an additional index to increase the speed.
I am very green when it comes to evaluating the execution plan and don't know the in's and outs of determining how to taylor an index correctly of if anything I am doing would affect the index selection (i.e. order of fields in the SELECT...order of fields in the WHERE clause...ect).
If anyone could give me some pointers or direction I would appreciate it very much...
Thanks,
Lee
September 17, 2007 at 3:03 pm
Can you post the code here? These kinds of things are alot easier if you can actually look at the queries involved.
Thanks
Kenneth Fisher
Kenneth FisherI was once offered a wizards hat but it got in the way of my dunce cap.--------------------------------------------------------------------------------For better, quicker answers on T-SQL questions, click on the following... http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]For better answers on performance questions, click on the following... http://www.sqlservercentral.com/articles/SQLServerCentral/66909/[/url]Link to my Blog Post --> www.SQLStudies.com[/url]
September 17, 2007 at 3:07 pm
I will update this either tonight or tomorrow morning as I need to leave at the moment...
Lee
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply