August 24, 2020


Optimizer Logical Trees Step-By-Step

Logical trees expose the early stages of optimization. This is a step-by-step guide to those trees, starting with the basics. Included are tips for getting queries to run faster.

Part 1 - Introduction
Part 2 - Overview of Trees and Operators
Part 3 - Getting and projecting; SQL FROM, SELECT
Part 4 - Filtering with the select operator; SQL WHERE

Coming soon: Part 5 - Joins and Apply

Special thanks to Paul White for providing an invaluable technical review of this series, and to Redgate for donating software.


No comments:

Post a Comment