Access Path II

• Bounded range search on indexed columns
• Unbounded range search on indexed columns
• Sort-merge join
• MAX or MIN of indexed column
• ORDER BY on indexed column
• Full-table scan

Notes: