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
What are key, name and value columns of an attribute? : sql server analysis services, ssas
How to select all columns of all rows from a table with a select statement in ms sql server?
What are the options which must be set to allow the usage of optimistic models?
How do users use Report Builder with SQL Server data sources?
Explain differentiate between a having clause and a where clause?
What is the need for indexing?
How do you set a trace flag in sql server?
How many types of dimensions are there and what are they? : sql server analysis services, ssas
in the physical file layout, where should the transaction log be stored in relation to the data file? : Sql server administration
Explain about Views?
Explain about sql server login?
what is raid and what are different types of raid configurations? : Sql server database administration
How can I know what locks are running on which resource?
How to declare and use cursor variables?
What is database isolation in sql server? : sql server database administration