Most queries filter a very large table by a date derived from a high-cardinality timestamp. What should a clustering-key evaluation consider?

Published
  1. Use every column in arbitrary order
  2. A useful date expression aligned with selective access patterns
  3. Assume clustering eliminates all scans for every query
  4. Always use a random UUID because it is unique

Comments — 0