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
- 10094 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
What is clustered vs nonclustered index?
What is checkpoint in sql server?
List some of the rules that apply to creating and using a ‘view’
How to list all field names in the result set using mssql_field_name()?
What are various aggregate functions that are available?
Why do we use functions?
What is the security principal at the database level that represents your session?
What is user-defined function?
Define Unique Key?
What are trace flags and mention a few common trace flags used with sql server?
What is a livelock?
Does hive support indexing?
What is the function of sql server agent windows service?
What is constraints and its types?
How to execute a sql statement using odbc_exec()?
