You're right Giani, there are indexes latest created.
Originally posted by Giani
Also Did you analyze you latest index created? if you don't that might be your problem.
check if somebody created an index recently :
where created=(select max(created) from dba_objects) ;
The table analyzed was :
then indexes were created,
and finally the table was analyzed again (compute).
The number of rows in the table is constant and wasn't growing.
I still don't understand why the analyzed takes such a long time ...
Any idea ?
Thanks a lot for all your advices !
Another precision ...
I've exported the table and its indexes on another database but in 8.1.7 release.
The analyze statement on the new database takes only 8 minutes ...
Click Here to Expand Forum to Full Width