i have learnt from one of the postings that analyze table "table_name" compute statistics will do for both table data and indexes