Query readiness: Organize data for chunk pruning
Pause
For
WHERE sym = 'AAPL'
, ordering lets the engine skip non-AAPL chunks.
Raw quotes
Unsorted
sym
day
AAPL
D1
MSFT
D1
NVDA
D2
AAPL
D2
MSFT
D1
NVDA
D2
AAPL
D1
MSFT
D1
NVDA
D2
Scanned 3 chunks
Grouped by day · Computed counts
Raw quotes
Ordered by sym
sym
day
AAPL
D1
AAPL
D2
AAPL
D1
MSFT
D1
MSFT
D1
MSFT
D1
NVDA
D2
NVDA
D2
NVDA
D2
Scanned 1 chunk · Skipped 2
Grouped by day · Computed counts