Interested to Buy Any Domain ? << Click Here >> for more details...
i want run a sql query query? which phases are run in a back
ground? pls tell me the answer
- 1 Answers
- 5267 Views
- I also Faced
- E-Mail Answers
Answer Posted / nitin
The phase of sql query execution is as follows.
1)Syntax Checking: Query will be checked if it is syntactically correct.
2)Semantic Checking:Query will be checked for user has rights on tables etc.
3)Cursor sharing:query will be checked against cursor sharing if soft parse can be done or hard parse required.
4)The creation of cost based decision tree for possible plans.
5)The execution of lowest cost execution plan.
6)Binding the execution plan.
7) Executing the query and fetching the rows.
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
What is the current version of sql?
Why do we use joins in sql?
What is form and report?
What is sql*loader and what is it used for?
What is trigger and types?
What is the usage of distinct keyword?
what are different types of keys in sql?
what is an alias command? : Sql dba
How is use pl and sql?
How do I run a pl sql program?
How many sql core licenses do I need?
What is the difference between stored procedure and view?
What is sql prepared statement?
What is mutating trigger?
What is a database trigger?
