i want run a sql query query? which phases are run in a back
ground? pls tell me the answer
- 1 Answers
- 4545 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
Explain 3 basic parts of a trigger.
What is a database? Explain
How to look at the current sql*plus system settings?
What is the largest value that can be stored in a byte data field?
How do I count rows in sql query?
How does a self join work?
What is not null in sql?
What is pivot query?
what is dbms? : Sql dba
Why is the cursor important?
What does (*) mean in sql?
What are user defined functions?
what is online transaction processing (oltp)? : Sql dba
how to dump a table to a file with 'mysqldump'? : Sql dba
Can we change the table name in sql?
