Skip to Content
avatar image
Former Member

Estimation of size of index on a table

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Sep 24, 2009 at 09:25 AM

    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

    Add comment
    10|10000 characters needed characters exceeded