Size of index before creation

[marcos_antoniomagalhesjun]

Hi colleagues!!

I have the table VBAK with 2,75 GB. I want create the ERD index for this table. This index exists in the dictionary abap but no there isn't in database. How can I check the size that I will need for do this.

[Former Member]

in that case why dont you recreate the index using SE14

[Former Member]

in that case why dont you recreate the index using SE14

Because he wants to know how much disk space the index will take when he creates it.

[stefan_koehler]

Hey Marcos,

please use the PL/SQL procedure dbms_space.create_index_cost to determine the needed disk space:

http://download.oracle.com/docs/cd/E14072_01/appdev.112/e10577/d_space.htm#i1002659

Regards

Stefan