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
- 5264 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 data modelling in sql?
What is sql analyzer?
What is a call statement? Explain with an example.
what are null values? : Sql dba
tell us something about heap tables. : Sql dba
What is composite primary key in sql?
What is column?
How do I create an index in word?
How do I order by ascending in sql?
how to drop an existing view in mysql? : Sql dba
What does subquery mean in sql?
What are sql*plus environment variables?
What is the current version of sql?
How to run pl sql program in mysql?
What type of database is sql?
