ASA SQL User's Guide Query Optimization and Execution Query execution algorithms
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