A query over a large Delta table repeatedly filters by customer_id, and scans far more files than needed. The team is considering a physical layout improvement. Which option is relevant?

Published
  1. Add ORDER BY customer_id to every query without changing storage layout
  2. Raise the query result row limit
  3. Evaluate liquid clustering using keys aligned with common filter patterns
  4. Cache only the result of an unrelated full-table query

Comments — 0