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);

Comments