[CASSANDRA-5514] Track min/max clustered values per sstable to optimize reads

• Type: New Feature
• Status: Resolved
• Priority: Normal
• Resolution: Fixed
• Fix Version/s: 2.0 beta 1
• Component/s: Legacy/CQL
• Assignee: Marcus Eriksson
• Reporter: Jonathan Ellis

Authors

Marcus Eriksson

Reviewers

Jonathan Ellis

• Created: 25/Apr/13 15:45
• Updated: 16/Apr/19 09:32
• Resolved: 24/May/13 15:43

Description

Slice queries can't optimize based on timestamp except for rare cases (CASSANDRA-4116). However, many common queries involve an implicit time component, where the application author knows that he is only interested in data more recent than X, or older than Y.

We could use the per-sstable max and min timestamps we track to avoid touching cold data if we could pass a hint to Cassandra about the time range we care about.