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
- 10220 Views
- Accenture, Polaris, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Explain trigger classes i.e. Instead of and after trigger?
How do you create a data source?
What is the difference between sql server 2000 object owner and sql server 2005 schema? : sql server database administration
How to write a query with an inner join in ms sql server?
What is an indice?
Explain the properties of subqueries in sql server?
you have couple of stored procedures that depend on a table you dropped the table and recreated it what do you have to do to reestablish those stored procedure dependencies?
Explain different types of Normalization.
Your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files?
What is transact-sql ddl trigger?
What is the importance of three tier architecture?
What is equi join with example?
What is the difference between sdf and mdf?
What are the differences between local and global temporary tables?
What is TDS(Tabular Data Stream) Gateway?
