Home » RDBMS Server » Performance Tuning » Never ending explain plan
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
Previous Topic: Listener stabilish
Next Topic: Question on indexes
Goto Forum:
  


Current Time: Tue Sep 22 07:40:27 CDT 2020