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

How do you check the performance of a query and how do you
optimize it?

Question Posted / guest


How do you check the performance of a query and how do you optimize it?..

Answer / guest

WE CAN EVALUATE THE QUERY PERFORMANCE BY RUNNING THE
EXECUTION PLAN OF THE QUERY.IF THE QUERY NEEDS ITS
PERFORMANCE TO BE OPTIMISED THEN WE WILL BE CREATE A VIEW
FOR THE TABLE USING 'WITH SCHEMA BINDING ' OPTION ,THEN
SUBSEQUENTLY CREATE A MATERIALISED VIEW USING INDEX
DEFINITION.FINALLY CHECK FOR THE EXECUTION PLAN (THAT
PREVENTS THE EXPENSE OF I/O READS).

Is This Answer Correct ?    6 Yes 3 No

Post New Answer

More SQL Server Interview Questions

What is clustered vs nonclustered index?

0 Answers  

What is the Difference beween sql server 2005 and sql server 2008

3 Answers   CMC, Hitech,

Define model database?

0 Answers  

How to transfer a table from one schema to another?

0 Answers   MCN Solutions,

How do we know if any query is retrieving a large amount of data or very little data?

0 Answers  




What are the operating modes in which database mirroring runs?

0 Answers  

How can we solve concurrency problems?

0 Answers  

How to loop through the result set with @@fetch_status?

0 Answers  

What authentication modes does sql server support?

0 Answers  

How to provide default values to stored procedure parameters?

0 Answers  

What is key set driven?

0 Answers  

Which trace flags are enabled in sql server?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories