Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

Suppose i have one sql query that contains 2 minute to
execute.After one weekly i am executing same query that is
taking 5 minute.Why our same query is taking more time.what
would be my approach to reduce execution time.Please help.

Question Posted / pankaj kumar


Suppose i have one sql query that contains 2 minute to execute.After one weekly i am executing sam..

Answer / rajkumar

1.It might be index failure please see execution plan
2.DO update statistics for that table and check once again.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL Server Interview Questions

what are the disadvantages of cursors? : Sql server database administration

0 Answers  

Hi all, can any one please tell me the difference between sql server 2008 and orace 9i

0 Answers   HP,

How to create prepared statements using odbc_prepare()?

0 Answers  

Define union, union all, minus, intersect?

0 Answers  

What type of locking occurs during the snapshot generation? : sql server replication

0 Answers  

What is the difference between SQL notification and SQL invalidation?

0 Answers   MindCracker,

What functions can a view be used to performed?

0 Answers  

How to get the definition of a trigger back?

0 Answers  

can anybody tell us, how to select 2nd max salary from table. my id is ashish.akk@gmail.com

28 Answers   IBM, Symphony,

difference between sql server2000 and sql server2005

1 Answers   KPMG,

What are a database and a data warehouse?

0 Answers  

Explain tablesample?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories