LIMIT Effectiveness

LIMIT Effectiveness

  1. PostgreSQL: row-store
  2. Snowflake: micro-partition pruning
  3. Iceberg: rich metadata parquet pruning
  4. Delta Lake: basic metadata parquet pruning
  5. BigQuery: columnar, MPP

Last modified on 2026-01-03