3. CTEs (20m)

Common Table Expressions (CTEs) look kinda like subqueries, but they have differences in how they perform. The good news is that they give you more readable queries with separate optimization pathways, and they can pull off tricks like filtering windowing function results and materializing hierarchies. The bad news – well, let’s get into the details….

To access this incredible, amazing content, you gotta get Fundamentals of Query Tuning or Recorded Class Season Pass, or log in if you already shelled out the cash.

Common Table Expressions (CTEs) look kinda like subqueries, but they have differences in how they perform. The good news is that they give you more readable queries with separate optimization pathways, and they can pull off tricks like filtering windowing function results and materializing hierarchies. The bad news – well, let’s get into the details....
To access this incredible, amazing content, you gotta get Fundamentals of Query Tuning or Recorded Class Season Pass, or log in if you already shelled out the cash.
Menu
{"cart_token":"","hash":"","cart_data":""}