Explain Plan problem - oracle toad [message #536039] |
Mon, 19 December 2011 01:36 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/8049638a3e1a52570b26bfc75d9e242f?s=64&d=mm&r=g) |
karafokas
Messages: 1 Registered: December 2011
|
Junior Member |
|
|
Hello,
I am having trouble executing a query in toad. I am using 15 tables from multiple locations (DMART tables and another schema). The problem is when i try to use the explain plan, the cost is 778 and 442 Bytes, the actual output is 1 line but it takes 20 minutes to execute. Can you give me some advice on where to start looking for the problem. I know that my sql is correct since the actual output is correct, but it takes so long.
Thank you in advance
George
|
|
|
|
|