Are the join columns all indexed? Does the query specify the join correctly? Thirty minutes is excessive, even with a 2.5-million row table. You should experiment with the use of different indexes and with optimizer hints to force different join orders and join algorithms.
Dig Deeper on Oracle database performance problems and tuning
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.