Can you post your entire sql. Are the tables being used IOT or normal table.
http://www.perf-engg.com A performance engineering forum
Forum Rules