Скачать или смотреть SQL Query Logical Processing - Part 2

Query processing order is one of the most fundamental aspects of SQL.
In this session we’re going to explore the sub-atomic structure of a SQL query from a fresh new angle which will bring radical new insights into SQL’s beauty and power.
You'll begin to see SQL queries through the eyes of the database engine, exactly as it processes each clause, unveiling the intricacies and logic of each. These new understandings will enable you to write more efficient, elegant queries, troubleshoot and optimize existing code with ease, and save many hours of frustration and hair pulling.
You'll learn:
• How the server REALLY processes your queries
• Logical implications of processing order
• Performance implications of processing order
• Understand and avoid common pitfalls