analyze table compute statistics for a table with two indexes
SQL>
SQL> set echo on
SQL>
SQL> create table t as
2 select * from all_objects;
Table created.
SQL>
SQL> create index t_idx1 on t(object_name);
Index created.
SQL>
SQL> create index t_idx2 on t(object_type);
Index created.
SQL>
SQL> analyze table t compute statistics
2 for all indexed columns
3 for table;
Table analyzed.
SQL>
SQL> drop table t;
Table dropped.
SQL>
SQL> --