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
- 7919 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
how to avoid cursors? : Sql server database administration
Can we linked SharePoint to a SQL database?
What is a trigger in sql server?
What is a heap?
What are the new scripting capabilities of ssms? : sql server management studio
How to test a dml trigger in ms sql server?
How you can get a list of all the table constraints in a database? : Sql server administration
Is it possible to create trigger on views?
How to update muliple row in single query?
What do you mean by acid?
What are the operating modes in which database mirroring runs?
List the different types of joins?
Explain the properties of a relational table?
How to turn on the mssql api module in php?
How to use subqueries with the exists operators in ms sql server?
