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
- 5263 Views
- I also Faced
- E-Mail Answers
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 |
What is forward declaration in pl sql?
What are the usage of SAVEPOINTS?
How to count the no of records of a table without using COUNT function?
Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me
What is union and union all keyword in sql?
how can i read write files from pl/sql
What is snowflake sql?
what is a relationship and what are they? : Sql dba
What is the difference between sql and t sql?
what is sql in mysql? : Sql dba
What are sql procedures?
can i call procedure in package
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
