Contents Index Sort Top N Filter, pre-filter and hash-filter

ASA SQL User's Guide
  Query Optimization and Execution
    Query execution algorithms

Miscellaneous


The following are additional methods that may be used in an access plan.


Filter, pre-filter and hash-filter
Lock
Row limit
Bloom filter
Explode

Contents Index Sort Top N Filter, pre-filter and hash-filter