This website uses cookies to ensure you get the best experience.
Learn more.
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
- Add ORDER BY customer_id to every query without changing storage layout
- Raise the query result row limit
- Evaluate liquid clustering using keys aligned with common filter patterns
- Cache only the result of an unrelated full-table query
Comments — 0
Sign in to comment