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
- 7843 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
Is the primary key column of a table an index in ms sql server?
Explain the difference between clustered and non-clustered index?
What are the different types of columns types constraints in the sql server?
Explain different types of index?
How to achieve Paging of records in SQL SERVER?
How to filter out duplications in the returning rows in ms sql server?
Describe the functionalities that views support.
Can a stored procedure call itself or a recursive stored procedure? How many levels of sp nesting is possible?
Can group functions be mixed with non-group selection fields in ms sql server?
Can we use where clause with group by?
What are the disadvantages of using the stored procedures?
What is sql server programming?
Explain primary key and foreign key constraints?
What are the authentication modes in sql server? How can it be changed?
How do I find my localdb version?
