i want run a sql query query? which phases are run in a back
ground? pls tell me the answer
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 minus?
Can a table contain multiple primary key’s?
List out the acid properties and explain?
What is the primary key?
What is sql query limit?
What are the operators in sql?
Is crud a cuss word?
How to move files from one directory to another in pl sql?
what is a relationship and what are they? : Sql dba
What is file based approach?
How to make a copy values from one column to another in sql?
What are tuples in sql?
What is the difference between having and a where in sql?
What is error ora-01000: maximum open cursors exceeded
how to drop an existing view in mysql? : Sql dba