i want run a sql query query? which phases are run in a back
ground? pls tell me the answer
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 |
Why we use sql profiler?
What is spool?
what are the different index configurations a table can have? : Sql dba
Is sql sequential or random?
Which function is used to return remainder in a division operator in sql?
What does plv msg allows you to do?
How is Oracle 10g helpful when compared to oracle 9i and what is grid computing
What is snowflake sql?
How many sql databases can you have on one server?
Is there any problem if we use commit repeatedly after each dml statement in a plsq procedure ? (eg. there are 10 update stmt and using 10 commit stmt after each update stmt)
what is variable in package specification
What is difference between inner join and self join?