asked on Last time indexes were rebuilt
Hi,
I will like to know when was the last time indexes were rebuilt.
I am using this query select distinct (LAST_ddL_TIME) as last from dba_objects, but DDL could mean some else besides rebuild for indexes ?
There is some automatic way to keep the indexes rebuild up to date automatically ?
I will like to know when was the last time indexes were rebuilt.
I am using this query select distinct (LAST_ddL_TIME) as last from dba_objects, but DDL could mean some else besides rebuild for indexes ?
There is some automatic way to keep the indexes rebuild up to date automatically ?
Oracle Database
Last Comment
johnsone
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
LAST_ANALYZED would work only if that is the only way you gather statistics. If you gather statistics another way outside that command (i.e. DBMS_STATS), then that column wouldn't be accurate.