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
- 5170 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
How do you update a value in sql?
List and explain the different types of join clauses supported in ansi-standard sql?
What is the difference between view and stored procedure?
What is database migration?
what is a database lock ? : Sql dba
what is dbms? : Sql dba
Write the alter statement to enable all the triggers on the t.students table.
what are the authentication modes in sql server? : Sql dba
How does postgresql compare to mysql?
Explain the difference in execution of triggers and stored procedures?
What is sql select statement?
What is constant in pl sql?
What is count * in sql?
Can we rename a column in the output of sql query?
Which certification is best for sql?
