Logical Query Processing Phases - Order of Statement Execution

home
database
view story

12 Kicks

Logical Query Processing Phases - Order of Statement Execution(blog.sqlauthority.com)

submitted by pinaldave(9662) 2 years, 10 months ago

SQL SERVER -What actually sets SQL Server apart from other programming languages is the way SQL Server processes its code. Generally, most programming languages process statement from top to bottom. By contrast, SQL Server processes them in a unique order which is known as Logical Query Processing Phase. These phases generate a series of virtual tables with each virtual table feeding into the next phase (virtual tables not viewable). These phases and their orders are given as follows:

add a comment |category: Database |Views: 191
Tweet