Stale index statistics but not analyzed
Hello guys.
We have Oracle 10g where it's supposed the statistics are collected automatically. Probably this question has been discussed previously.
Some times we have performance problems and the other day I got a query which I analysed with the SQL Tunning Advisor. It said to optimizer statistics for some indexes because they are stale. Then I check it and the last analysed where on 2013, I also check the statistics status and the indexes are market as stale.
select index_name,last_analyzed, stale_stats
from dba_ind_statistics
where index_name = 'FRJ901';
INDEX_NAME | LAST_ANALYZED STALE_STATS |