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



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 ms sql server index?

0 Answers  


Does sql server 2016 have ssms?

0 Answers  


How To delete duplicate record from a particular table?

12 Answers   eXensys, Foxfire,


How do I schedule a sql server profiler trace?

0 Answers  


How many types of Outer Joins?What are they?

1 Answers  






what is meant by sql injection with example and one more question how to catch the errors in sqlserver

2 Answers  


Can you explain what are the restrictions applicable while creating views? : SQL Server Architecture

0 Answers  


What are date and time data types in ms sql server?

0 Answers  


What is compression - row-level and page-level compression?

0 Answers  


What is acid properties?

0 Answers  


Can we hide the definition of a stored procedure from a use?

0 Answers  


What stored by the tempdb ? : sql server database administration

0 Answers  


Categories