Estimation of size of index on a table

[Former Member]

hi all,

how can we estimate the size of index on a table? Exmaple - suppose a table has a million records with ten columns and if we do indexing on this table with four columns in where used conditions. then what is the size of index? how to calculate it?

thanks

anubhav

[stefan_koehler]

Hello Anubhav,

there is a PL/SQL procedure called DBMS_SPACE.CREATE_INDEX_COST ... this is exactly what you are searching for.

http://download.oracle.com/docs/cd/B19306_01/appdev.102/b14258/d_space.htm#i1002659

Regards

Stefan