Query to Estimate Index Size before creation

 

1. Generate  execution plan for create index query

       
explain plan 
for
CREATE UNIQUE INDEX VVS.IDX_ABC_NO ON VVS.ABC (NO) tablespace USERS NOLOGGING ; 

2. Report  the execution plan detail 

select * from table(dbms_xplan.display);