What is Query Execution Plan? How does it help optimize or
tune a database driven application?
- 2 Answers
- 9547 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 |
Explain different types of Normalization.
1 Answers HPCL, Hughes Systique Corporation, Ittiam Systems,
Can we have more than one NULL in a column having unique constraint?
What is the downside of using udf?
What is compound operators?
What is a sql join?
Well sometimes sp_reanmedb may not work you know because if some one is using the db it will not accept this command so what do you think you can do in such cases?
What are orphan records?
What will be the maximum number of indexes per table?
What is a partitioned view?
What is transaction server implicit?
What is @@error in sql?
What is the difference between DTS and SSIS?
-
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)
