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
Part 2 - Overview of Trees and Operators
Part 3 - Getting and projecting; SQL FROM, SELECT
Part 4 - Filtering with the select operator; SQL WHERE
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