Hi, all: I have been using dbms_utility.analyze_schema to collect stats. I know Oracle recommends using dbms_stats pkg. So, I tried it today. Here is the weird thing, after I used dbms_stats.gather_schema_stats, i queried user_tables and user_indexes. the last_analyzed column for user_tables were updated, but for user_indexes, the column is not updated. I also used gather_table_stats, same thing, it only updated user_tables, but not user_indexes. Anybody has the same experience? I am using Oracle 188.8.131.52 on aix 5.2. I only used schema_name as the parameter for gather_schema_stats.
p.s. if I use dbms_utility.analyze_schema, both user_tables and user_indexes are updated.