What is Query Execution Plan? How does it help optimize or
tune a database driven application?
- 2 Answers
- 9560 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 the stuff?
What is the use of builtinadministrators group in sql server? : sql server security
What are the diifferences between the ms sql server vs mysql?
What is the difference between an index and a unique index?
What is the maximum size of a row in sql server?
Can binary strings be used in arithmetical operations?
Why de-normalization required?
Explain four layers of abstraction microsoft architectured?
What are different types of statement?
What is sql profiler. What are the default templates with it? : sql server database administration
How to list all columns in a table using odbc_columns()?
List out different types of normalizations in sql server and explain each of them?
hi, the following are the outputs of sp_spaceused and sp_tempdbspace sp_spaceused ------------ database size unallocated size tempdb 77752.95 MB 28026.99 MB sp_tempdbspace ------------- database size spaceused tempdb 77752.945312 1.007812 the unused space in sp_spaceused is nearly 28 Gb and in sp_tempdbspace is nearly 76 Gb cany any one explain about this output and why its giving different results.
What gets stored inside msdb database?
What are the different subsets of sql?
