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
- 5349 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
Are stored procedures faster than dynamic sql?
How many triggers can be applied on a table?
What is the purpose of normalization?
List and explain the different types of join clauses supported in ansi-standard sql?
What is the usage of the distinct keyword?
What are different categories of sql commands?
Can we write ddl statements in functions?
what is the syntax used for partition in tsql? : Transact sql
What is the difference between inner join and natural join?
what is the difference difference between procedure and packages
How do I enable sql encryption?
Does inner join remove duplicates?
Explain correlated query work?
What is the difference between union and union all command?
What is orm in sql?
