Low-latency queries: Optimizations you can make today to power data-intensive apps from your data warehouse
Matan Sarig explores some of the traditional techniques, like indexing, as well as modern techniques that make your queries go from fast to fastest in the cloud.
00:00--What is a data app
07:41--Improve data pruning using clustered indexes
13:09--Eliminate JOIN using arrays
20:50--Accelerate UPSERT using PARTITIONS
28:23--Schema evolution using JSON and LAMBDA