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 Transform…