Hi,

I want to know wheather analyze table will analyze all indexes in that table or wheather we have to explicitely analyze indexes.

Analyze table tbl_name compute statistics;
or
Analyze table tbl_name estimate statistics 1000 rows;


Thanks in advance

Paresh