Session

Database & SQL Performance Tuning - What Happens to Data Types as They Enter the Shadows of the Data

📌 TL:DR - This presentation explores key encoding strategies, Offset Encoding, Dictionary Encoding, Bit-Packing, RLE, and Delta Encoding, and how data ordering influences their efficiency. You'll learn how data type selection affects query execution, encoding efficiency, and cost optimization in modern data warehouse systems.

🎯 Key Takeaways
By the end of this session, you should walk away with a clear understanding
* How your choices in data type selection can influence a data warehouse, potentially lowering costs through efficient encoding
* How do DuckDB/Parquet (open-source), Google BigQuery & Azure Synapse Dedicated Pool (VertiPaq Engine) implement this in reality?
* How your data type affects query execution by limiting operator choices or leveraging low-level CPU features like Single Instruction, Multiple Data (SIMD).

Rif Kiamil

I teach and educate about Data, SQL & Google BigQuery

London, United Kingdom

Actions

Please note that Sessionize is not responsible for the accuracy or validity of the data provided by speakers. If you suspect this profile to be fake or spam, please let us know.

Jump to top