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
- 7896 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
Where can you add custom error messages to sql server?
Introduction of rollup clause using sum and group by clause?
Explain foreign key in sql server?
1.what is the diff between nolock optimizer and read uncommitted isolation? 2.what is the diff between revoke and deny? 3.what is percieved down time? 4.whether password protection are required for backups?if yes why?if no why? 5.what is fill factor? 6.what is cost analysis? 7.what is mean by piece meal restore? 8.what is 'rowguidcol'? 9.impersonate permission? 10.what is selectivity?
What are diverse clauses that form a part of sql?
What is sharding?
What is shrink log file?
What are date and time data types in ms sql server?
What are the different types of lock modes in sql server 2000?
What is not null constraint?
How do I delete a sql server database?
What is the security principal at the database level that represents your session?
Explain what are sparse columns?
what is denormalization and when would you go for it? : Sql server database administration
Does a server store data?
