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
- 5241 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 |
how to create a new view in mysql? : Sql dba
What is update query?
What is Difference Between delete and Truncate?
wtite down triggr not any entry on Sunday
What is a trigger word?
Explain how you can copy a file to file content and file to pl/sql table in advance pl/sql?
Why we use joins in sql?
How do you exit in sql?
What is the difference among union, minus and intersect?
how to check the 3rd max salary from an employee table?
What is set transaction?
What's the difference between a primary key and a clustered index?
-
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)
