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
- 5238 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
Differentiate between % rowtype and type record.
What is embedded sql what are its advantages?
What is a primary key sql?
What is a data definition language?
What is pl sql block structure?
What are string functions in sql?
Explain how exception handling is done in advance pl/sql?
Explain how can you save or place your msg in a table?
What are literals in sql server?
Is sql dba a good career? : SQL DBA
What is the difference between subquery and correlated query?
Is nosql faster than sql?
How many scalar data types are supported in pl/sql?
What is pl sql quora?
What is an alias command?
