Tell me what is the order in which the SQL query is executed?
Submitted by: AdministratorThe following is the order of executing SQL query:
The query goes to the shared pool that has information like parse tree and execution plan for the corresponding statement.
Then validates the SQL statement and validates the source(table).
Acquire locks.
Checks all the privileges.
Execute the query.
Fetch the values for SELECT statement
Displays the fetched values.
To sum up, the sequence is:
SELECT .........
FROM ..........
WHERE ..........
GROUP BY ...........
HAVING .............
Submitted by: Administrator
The query goes to the shared pool that has information like parse tree and execution plan for the corresponding statement.
Then validates the SQL statement and validates the source(table).
Acquire locks.
Checks all the privileges.
Execute the query.
Fetch the values for SELECT statement
Displays the fetched values.
To sum up, the sequence is:
SELECT .........
FROM ..........
WHERE ..........
GROUP BY ...........
HAVING .............
Submitted by: Administrator
Read Online SQL Database Concepts Job Interview Questions And Answers
Top SQL Database Concepts Questions
| ☺ | Explain what are Magic tables in SQL Server? |
| ☺ | Do you know how to send email from database? |
| ☺ | How to search for a string in all stored procedure in SQL Server? |
| ☺ | Explain how to use Linked Server? |
| ☺ | Explain difference between cross join and Full outer join? |
Top New MS SQL Server Categories
| ☺ | SQL Server Database Administrator Interview Questions. |
| ☺ | SQL Server Service Broker Interview Questions. |
| ☺ | SQL Server Locks Interview Questions. |
| ☺ | SQL Server Constraints Interview Questions. |
| ☺ | MS SQL Data Mining Interview Questions. |
