Interested to Buy Any Domain ? << Click Here >> for more details...
What is Query Execution Plan? How does it help optimize or
tune a database driven application?
- 2 Answers
- 10353 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 are four major operators that can be used to combine conditions on a where clause?
What are the underflow and overflow behaviors on float literals?
How use inner join in sql server?
On a windows server 2003 active – passive failover cluster, how do you find the node which is active?
How can we use ConnectorJ JDBC Driver with MS SQL?
how many no of arguments can be passed in procedures and functions
your distribution database is full what will u do
What is better - 2nd Normal form or 3rd normal form? Why?
How to delete a login name in ms sql server?
What do you mean by table and field in sql?
Explain the architecture of ms sql reporting service?
What is efficiency data?
-
Oracle (3253) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
