What is Query Execution Plan? How does it help optimize or
tune a database driven application?
- 2 Answers
- 9269 Views
- Accenture, Polaris, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / arthanari r
When hte SQL statement is executed Oracle designs an
execution plan for it. This execution plan is basically a
step by step instruction for how the statement must be
executed. That is, the order in which tables are read, if
indexes are used, which join methods are used to join
tables and so on. The execution plan for an SQL statement
can be viewed with the explain plan statement. The query
execution plan is elaborated during an SQL statement's
parse phase.
| Is This Answer Correct ? | 7 Yes | 0 No |
Answer / racing
When the SQL statement is executed Oracle designs an
execution plan for it. This execution plan is basically a
step by step instruction for how the statement must be
executed. That is, the order in which tables are read, if
indexes are used, which join methods are used to join
tables and so on. The execution plan for an SQL statement
can be viewed with the explain plan statement. The query
execution plan is elaborated during an SQL statement's
parse phase.
| Is This Answer Correct ? | 3 Yes | 1 No |
What is the parse query button used for?
What is a covering index?
Can you change the data type of a column in a table after the table has been created? If so, which command would you use?
What is measure group, measure? : sql server analysis services, ssas
What is meant by datasource?
What command is used to rename the database?
How many non clustered indexes there can be on table ?
Why use “in” clause in sql server?
Why do we backup Active Directory ?
event classes in sql server
Explain about system stored procedure?
How to create a scrollable cursor with the scroll option?
-
Oracle (3239) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3312)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1391)
- Databases AllOther (288)
