/* $Id$ */
/*============================================================================*
 |                 Copyright (c) 2012 Applaud Solutions UK Ltd                |
 |                             All rights reserved                            |
 *===========================================================================*/

SET VERIFY OFF
SET FEEDBACK OFF
WHENEVER OSERROR  EXIT FAILURE ROLLBACK
WHENEVER SQLERROR EXIT FAILURE ROLLBACK

CREATE INDEX XXAS_PERF_PLAN_ENROLLMENTS_FK1
       ON XXAS_PERF_PLAN_ENROLLMENTS (PERF_PLAN_ID)
       TABLESPACE APPS_TS_TX_IDX;

CREATE INDEX XXAS_PERF_PLAN_ENROLLMENTS_NK1
       ON XXAS_PERF_PLAN_ENROLLMENTS (PERSON_ID)
       TABLESPACE APPS_TS_TX_IDX;

CREATE INDEX XXAS_PERF_PLAN_ENROLLMENTS_NK2
       ON XXAS_PERF_PLAN_ENROLLMENTS (ASSIGNMENT_ID)
       TABLESPACE APPS_TS_TX_IDX;

COMMIT;
EXIT;
