What is Query Execution Plan? How does it help optimize or
tune a database driven application?
Answer Posted / 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 |
Post New Answer View All Answers
What is a fan-out query in SQL Azure?
Explain what is log shipping?
How can we delete a table in sql server?
where the connection string store in the database
what is the difference between delete table and truncate table commands? : Sql server database administration
Determine when an index is appropriate?
What are the tables in sql?
What are scalar functions?
What is the simplest way to create a new database in ms sql server?
Does sql server 2016 have ssms?
Can I delete event logs?
What does dml stand for?
What is key set driven?
Distinguish between nested subquery and correlated subquery?
What is rank function?