i want run a sql query query? which phases are run in a back ground? pls tell m

i want run a sql query query? which phases are run in a back
ground? pls tell me the answer

Question Posted / praveen

1 Answers
4851 Views
I also Faced
E-Mail Answers

i want run a sql query query? which phases are run in a back ground? pls tell me the answer..

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