ALTER INDEX REBUILD

SQL>analyze table hr.prueba validate structure;

EJECUTAR EL SCRIPT

SQL>analyze index hr.EMP_EMAIL_UK VALIDATE STRUCTURE;

NOTA: VALIDAR SI EL PORCENTAJE ES MAYOR AL 20%

SQL>select name, del_lf_rows/lf_rows*100 reclaimable_space_pct from index_stats where name='EMP_EMAIL_UK';

SQL>alter index hr.EMP_EMAIL_UK rebuild;

SQL>alter index hr.EMP_EMAIL_UK monitoring usage;

SQL>  alter index hr.EMP_EMAIL_UK invisible;

Index altered.

SQL>  alter index hr.EMP_EMAIL_UK visible;

Index altered.

SQL> SELECT index_name, used, monitoring from v$object_usage where index_name = 'EMP_EMAIL_UK';

no rows selected

SQL> alter index hr.EMP_EMAIL_UK invisible;

Index altered.

SQL> alter index hr.EMP_EMAIL_UK visible;

Index altered.

SQL>