full table scan, index scan, index-only access, or something else - **Which indexes** are used, and how many key columns match the predicates - **How tables are joined** — nested loop, merge scan, or hash join - **Where sorts occur** and why - **Estimated costs** — how expensive the optimizer thinks