Data Structures
- Heap-Organized Tables
- B-Tree Indexes and IOTs
- Bitmap Indexes
- Table Clusters
Algorithm
Query Transformations
- OR Expansion
- View Merging
- Predicate Pushing
- Subquery Unnesting
- Query Rewrite with Materialized Views
- Star Transformation
- In-Memory Aggregation
- Table Expansion
- Join Factorization
Access Paths
- Table
- Full Table Scans
- Table Access by Rowid
- Sample Table Scans
- Index
- Index Unique Scans
- Index Range Scans
- Index Full Scans
- Index Fast Full Scans
- Index Skip Scans
- Index Join Scans
- Bitmap Index
- Bitmap Index Single Value
- Bitmap Index Range Scans
- Bitmap Merge
- Bitmap Index Range Scans
- Cluster
- Cluster Scans
- Hash Scans
Join
- Join Methods
- Nested Loops Joins
- Hash Joins
- Sort Merge Joins
- Cartesian Joins
- Join Types
- Inner Joins
- Outer Joins
- Semijoins
- Antijoins
- Join Optimizations
- Bloom Filters
- Partition-Wise Joins
Statistics Types
- Table Statistics
- Column Statistics
- Index Statistics
- Session-Specific Statistics for Global Temporary Tables
- System Statistics
- User-Defined Optimizer Statistics