10_Index_Analyzed.sql

10_Index_Analyzed.sql

select OWNER,index_NAME,to_char(LAST_ANALYZED,'DD/MON/YYYY-HH24:mi')

from dba_indexes

where owner = '&OWNER'

order by LAST_ANALYZED DESC

/