How do you check the performance of a query and how do you
optimize it?
- 1 Answers
- 7545 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 the process of normalising?
Can you move the resources after pausing the node? : sql server database administration
Can we write a distributed query and get some data which is located on other server and oracle database?
What are the general features of sql server management studio? : sql server management studio
How to configure odbc dsn with different port numbers?
How do you check sql server is up and running?
What is the difference between Normalization and De-normalization?
Is mysql better than sql server?
How self join is different from outer join?
How to disable a login name in ms sql server?
Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down?
do you know how to configure db2 side of the application? : Sql server database administration
What do you understand by physical_only option in dbcc checkdb?
Explain what role entity and relationship play in an ER diagram.
Where in ms sql server is ’100’ equal to ‘0’?
