August 29, 2007 at 10:45 am
Dear Experts,
I have faced the below question in an interview.
-----------------------------------------------------------------
What is one of the first things you would do to increase performance of a query? For example, a boss tells you that “a query that ran yesterday took 30 seconds, but today it takes 6 minutes”
-------------------------------------------------------------------
Inputs are Welocme !
Regards
Karthik
karthik
August 29, 2007 at 10:59 am
If the query hasn't changed (and doesn't have variabled inputs) then I would probably defrag the indexes (or rebuild), run sp_updatestats and DBCC UPDATEUSAGE.
If it has changed due to variable input I would look at the execution plan for the previou query an the new. Index utilization is going to be an item you want to look at.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply