Diagnosing a Slow Query

When a query is slow, the key is to work from facts—not guesses. You don’t need to be an expert in Oracle internals, but you do need to capture what the database is doing and compare that to what you expected. This section walks you through a simple and repeatable process.