Posts

All the articles I've posted.

• 8 MIN READ•Apr 29, 2026

  Inside the Query Optimizer: How Engines Pick a Plan

  Query optimizers transform SQL into execution plans using rule-based rewrites, cost-based search, and adaptive runtime adjustments. Here is how each approach works.

  query optimizercost-based optimizationquery planning
• 8 MIN READ•Apr 29, 2026

  Partition Evolution: Change Your Partitioning Without Rewriting Data

  Iceberg lets you change partition schemes without rewriting data. Here is how partition evolution works internally and why Hive-style partitioning could not do this.

  Iceberg partition evolutionpartition spechidden partitioning
• 8 MIN READ•Apr 29, 2026

  B-Trees, LSM Trees, and the Indexing Tradeoff Spectrum

  B-trees balance reads and writes for OLTP. LSM trees maximize write throughput. Bitmap indexes accelerate OLAP filtering. Here is when to use each.

  database indexing strategiesB-tree vs LSM treebitmap index