ORACLE PL SQL

 CONSULTAR EL PLAN DE EJECUCION

EXPLAIN PLAN FOR

        SELECT * FROM TABLE WHERE FILTER =FILTER_VALUE;

SELECT plan_table_output

FROM TABLE(DBMS_XPLAN.DISPLAY('plan_table',null,'basic +predicate +cost'));

 USO DE INDICES

CONSULTAR INDICES DE UNA TABLA	CONSULTAR COLUNAS INDEXADAS POR INDEX
select * from v$object_usage where table_name = 'NOMBRE_TABLA' Para desactivar el monitoreo:	select table_owner, index_name, column_position pos, substr(column_name, 1, 30) column_name from all_ind_columns where table_name = upper('SIPAI_TABLA_PLANA_RPT_CONSOLIDADO') order by table_owner, index_name, pos;
Eliminar el indice  drop index NOMBREINDICE;	Crear Indice CREATE INDEX "INDICE_NAME" ON "TABLE_NAME" ("CAMPO_INDEX");