on 09-24-2009 10:11 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
10 | |
10 | |
10 | |
7 | |
6 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.