How do you check the performance of a query and how do you
optimize it?
Answer Posted / 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 View All Answers
How to delete all rows with truncate table statement in ms sql server?
You want to use a perspective in an mdx query. How do you select the perspective?
How to change server name in sql server?
How to defragment table indexes?
Why is normalisation important?
What are the different types of lock modes in sql server 2000?
What is the standby server?
What is clr ddl trigger?
1.how to find the dead lock in sql server? 2.How to fine the memory leaks in sql server? 3.suppose transaction log file increasing what action will take ?
Why do we use trigger?
How to find the service pack installed? : sql server database administration
Why would you call update statistics?
What is rank function?
In which sql server version report builder introduced?
How to send email from database?