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
What are drilldown reports?
Mention the different types of replication in sql server.
What is @@error in sql?
What is the fastest way to permanently delete a 1 million row table named customers?
What method is used by the Command classes to execute SQL statements that return single values?
What are the fixed server level roles? : sql server security
What are different types of raid levels?
What is a partitioned view?
You have modified 100 store procedures and want to replicate these changes from development to prodution, and production can have users using the Server/DB, how would you replicate without causing issues?
How do I start and stop sql server?
What are the default system databases in sql server 2000?
How to create an identity column?
Is sql server 2016 free?
Do you know what is difference between stored procedure and user defined function?
What are the purpose of Normalisation?