What is the order in which the SQL query is executed? list
them in order.
- 5 Answers
- 10840 Views
- CarrizalSoft Technologies, CTS, Oracle, I also Faced
- E-Mail Answers
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 to attach adventureworkslt physical files to the server?
How much does sql server 2016 cost?
What is named calculation? : sql server analysis services, ssas
Does a specific recovery model need to be used for a replicated database? : sql server replication
What is user-defined scalar function?
How to check what was the last restore transaction LSN in Log shipping or Mirroring? when we don't have a Monitor or witness server.
How extra digits are handled with numeric data type literals?
List the different types of collation sensitivities in sql server?
what is an index? : Sql server database administration
Explain the concept of recursive stored procedure.
What is difference between delete & truncate commands?
Do you know what is a linked server in sql server?
Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?
Explain Reporting Life Cycle?
How to create an identity column?
