How to estimate index sizing ?

Hi all,

  If i have some sample data for table, i can actually use it for my   table and index sizing by using analyze command.

 For table, i can use user_tables.avg_row_len * estimate row for my  table after anayze the table.

 For index, how do i get the avg_row_len ? i can't find it from  user_indexes.

Can anyone tell me how ?

Thank you

Regards, ypc

--
Posted via dBforums
http://dbforums.com