Never ending explain plan [message #65495] |
Thu, 07 October 2004 01:17 |
Nicola Farina
Messages: 63 Registered: October 2001
|
Member |
|
|
Hi all
I have a query that I need to optimize but ....
Generally for start tuning I use :
set autotrace traceonly explain
and then I look at the plan
Now my problem is that in this query the plan generation goes forever and took all the server's cpu resources
The db is 8.1.7.4
Note that the same query with the same database (just exp and imp) in 9i goes istantly
This query selects data from a view of view of view and so on.. It is a quite complicated structure..
I am not sure that all the base tables of these views have all indexes properly defined..
My question is
Is there any tool (in 8i) that may help in finding missing indexes or statistics?
Thanks in advance
bye
Nicola
|
|
|