How to Diagnose a Slow Oracle SQL Query Before Adding Another Index

Picture this: It's 11 p.m. You've had five Oreos from the office vending machine, and a healthcare claims report that has been finishing in about 10 seconds for months is now 15 minutes in and still r