What is the order in which the SQL query is executed? list
them in order.
Answer Posted / l. meher
When a SQL query is getting executed it goes through the
following steps:
1) It goes to the shared pool which contains information
such as the parse tree and execution plan for the
corresponding statement.
2)Validate the SQL statement.
3)Validate the source.
4)Acquire locks.
5)Checks for previllages.
6)Parse the statement.
7)Execute the Query.
8)Fetch the value (only for select statement).
9)Generate the redo information.
If you have any doubt mail me at lmeher.tcs@gmail.com
Thanks..
| Is This Answer Correct ? | 5 Yes | 4 No |
Post New Answer View All Answers
How the authentication mode can be changed?
how to take backup bcp out for a column in table in sql server?
Do you think BCNF is better than 2NF & 3NF? Why?
What is the difference between primary key and unique constraints?
How many types of local tables are there in sql server?
Explain what is lock escalation and what is its purpose?
Where views are stored in sql server?
What is transaction server isolation?
What do you mean by 'normalization'?
How do I start sql server agent automatically?
How to use the inserted and deleted pseudo tables?
how will add additional conditions in sql?
Explain what is the difference between a local and a global temporary table?
Is null vs coalesce?
What are the 10 characteristics of data quality?