[CASSANDRA-15913] Avoid "ALLOW FILTERING" requirement for multiple restricted columns if index can handle them

• Type: Improvement
• Status: Triage Needed
• Priority: Normal
• Resolution: Unresolved
• Component/s: Feature/SASI
• Platform: All
• Assignee: Unassigned
• Reporter: Zhao Yang
• Created: 02/Jul/20 12:11
• Updated: 02/Jul/20 12:11

Description

When executing following query, "ALLOW FILTERING" is required even if both columns are indexed by SASI and used in QueryPlan:

SELECT * FROM table WHERE age="20" and address="SF"

We should consider providing a proper "QueryPlan" under "Index" interface to avoid "ALLOW FILTERING" when all restricted columns are handled by index.