Interested to Buy Any Domain ? << Click Here >> for more details...
What is the order in which the SQL query is executed? list
them in order.
- 5 Answers
- 11630 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
What is sql server profiler trace data file?
What command must you use to include the not null constraint after a table has already been created?
How to get a list all databases on the sql server?
Explain tables in SQL Azure?
Define a cross join?
Why should you use or avoid select * statements?
What is an execution plan?
How do you create type- insensitive operator?
How do I connect to sql server database?
Explain the truncate command? : SQL Server Architecture
How to change server name in sql server?
What is the purpose of linked server configuration in sql server?
how would you troubleshoot blocking? : Sql server database administration
Write down the syntax and an example for create, rename and delete index?
What are indexers?
