Taral Desai wrote:
Well this is not in parallel. So, may be something else is doing some other run on server. Or may be this would run in parallel at runtime.
1. Is there parallel set at table level ?
2. Some of the table are not analyzed .
3. some predicates are applied very late so may be you can try sub query unnesting