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.
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.