Opposed to physical query processing which follows the order of the statements:
SELECT .. FROM .. WHERE.. GROUP BY ..)
logical query processing processes the statements in the following order:
FROM .. WHERE .. GROUP BY .. SELECT ..
Last week I saw this excellent poster from (who else then) Itzik Ben Gan, writing down the phases of logical query processing in T-SQL in a flow diagram.
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgI2jQ-MVpMxw1R40AaAlMKCMLib5vEdt8uJVGRiCmDFnS3PWM4_z_UxhjbwmfSKB7Io2ST5enEYhywrJ7MfVHNLrNcE1uWYpH0hMDhyy37FgRA0nLhoYiLZPQAqno1NQUuMrgmXS2LqO8/s640/LogicalQueryProcessingPoster.png)
You can download the original poster here.
ReplyDeleteThis blog Contains more useful information, thanks for this blog...
What is Power BI
Features of Power BI
Pro and Premium Power BI