Does dbms_stats collects statistics for invisible indexes?
The answer is yes, Although the invisible indexes does not used by optimizer but they should be ready when it needed, hence the dbms_stats collects the statistics on the invisible indexes too.
Here is small test case.
SQL> select to_char(last_analyzed,’YYYY-MM-DD HH24:MI:SS’), VISIBILITY from dba_indexes where index_name=’IDX_MTD’; […]
Follow Me!!!