Interested to Buy Any Domain ? << Click Here >> for more details...
How do you check the performance of a query and how do you
optimize it?
- 1 Answers
- 7985 Views
- I also Faced
- E-Mail Answers
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
What is faster join or union?
How to delete duplicate rows in sql server?
Explain system views?
Why is sql server log file full?
Tell me what is difference between clustered and non clustered index?
What are commonly used mssql functions in php?
What is the most common trace flags used with sql server?
How will you add a dimension to cube? : sql server analysis services, ssas
What does man by sql wildcard characters in sql server?
what is blocking? : Sql server database administration
What kind of problems occurs if we do not implement proper locking strategy?
what is database replication? : Sql server database administration
What is clustered primary key?
What does it mean if @@cursor_row returns a negative number?
Explain having clause?
