-
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 :
select OWNER,OBJECT_NAME,OBJECT_TYPE,CREATED,LAST_DDL_TIME,STATUS
from dba_objects
where created=(select max(created) from dba_objects) ;
You're right Giani, there are indexes latest created.
The table analyzed was :
first truncated,
then inserted,
analyzed (compute),
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 ...
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|