Optimize Oracle Query

Interview question

Describe a time you improved Oracle SQL performance for a slow-reporting query: what specific change did you make (indexes, hints, rewrite, or statistics) and why?