What is Query Execution Plan? How does it help optimize or
tune a database driven application?
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 |
How to convert a unicode strings to non-unicode strings?
What is difference between clustered index and non clustered index?
Can you change the data type of a column in a table after the table has been created? If so, which command would you use?
What does man by sql wildcard characters in sql server?
What is a collation?
How maney row would be print after join if A table have 100 rows and B table have 50 rows...
As per your opinion what are the five top responsibilities of a dba? : sql server database administration
What is the difference between ‘having’ clause and a ‘where’ clause?
What is the fastest way to permanently delete a 1 million row table named customers?
Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?
What do you mean by cardinality?
When we are using this query to shrink the log file,what exactly it will execute internally? Do we lose any data when we run this script? which data it will truncate in the log file and where it is saved. Please let me know... USE DatabaseName GO DBCC SHRINKFILE(<TransactionLogName>, 1) BACKUP LOG <DatabaseName> WITH TRUNCATE_ONLY DBCC SHRINKFILE(<TransactionLogName>, 1) GO