In this session, we will walk through the main optimization techniques - starting with classic indexes (B-Tree) for relational databases, via Z-Order, and Liquid Clustering for Lakehouses, and ending with the V-Order mechanism, recently introduced by Microsoft.

We will delve into the mathematical foundations behind the mechanisms to fill in some gaps and mention concepts that are often overlooked when presenting these techniques. But don't be scared, We'll introduce this theoretical knowledge in a very accessible way!

We'll cover sorting, partitioning, the origin of the Z-Order curve, and many others. We'll also break down the Parquet file into its components to fully understand how different pushdown mechanisms work.

We will talk about optimization techniques that you already know, but we'll do it in a way different than usual ;).