Display INDEX_NAME, LAST_ANALYZED and DAYS_AGO by having the difference between the last analyzed date and the current date from the all_indexes view.
asked
I need to know the query statement for this
ALL_INDEXES is an Oracle, thing, you would just get the information you need by selecting the right pieces from the view along with using date math (lookup DATEDIFF) for this.
select owner, index_name, last_analyzed, global_stats
from dba_indexes
where owner not in (‘SYS’,’SYSTEM’)
order by owner, index_name
16 People are following this question.
