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...


What are the steps you will take to improve performance of a
poor performing query?



What are the steps you will take to improve performance of a poor performing query?..

Answer / m.sivakumar

Some general issues that you could talk about would be:

No indexes,
table scans,
missing or out of date statistics,
blocking, excess recompilations of stored procedures,
procedures and triggers without SET NOCOUNT ON,
poorly written query with unnecessarily complicated joins,

too much normalization, excess usage of cursors and temporary
tables.

Is This Answer Correct ?    8 Yes 1 No

Post New Answer

More SQL Server Interview Questions

How to list all stored procedures in the current database using ms sql server?

0 Answers  


What is the difference between count and distinct count?

0 Answers  


What is the default sql server instance name?

0 Answers  


Why use stored procedures in sql server?

0 Answers  


What is after dml trigger?

0 Answers  


How to use linked server?

0 Answers  


Define ACID properties in a Database?

0 Answers   iNautix,


How to list all objects in a given schema?

0 Answers  


How to convert a table data in XML format in sql server?

0 Answers  


What is DAC? what is the use of it?

1 Answers   Wipro,


What is update locks?

0 Answers  


How to find table changes in sql server?

0 Answers  


Categories