How do you check the performance of a query and how do you
optimize it?
- 1 Answers
- 7542 Views
- I also Faced
- E-Mail Answers
Answer / 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 |
What is a sql join?
What is b tree index?
What are triggers in ms sql server?
what type of indexes physically sort data?
Which feature in sql server 2008 has surprised you? You can name just one. : sql server database administration
Do comments need to go in a special place in sql server 2005?
Explain the steps needed to create a scheduled job?
What is dbcc?
What is resource governor?
How to manipulate data from one table to another table ?
Differentiate between ms sql server reporting services vs crystal reports?
How to select an exiting database using mssql_select_db()?
-
Oracle (3258) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3328)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
