/**Begin D:\softwaresetup\PDM_UPGRADE\PDM1\FPM_constraint.sql **/
 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_FPMMEMBER_L_FID') CREATE INDEX IDX_FPMMEMBER_L_FID ON T_FPM_MEMBER_L ( FID );

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_FPM_DIMID') CREATE INDEX IDX_FPM_DIMID ON T_FPM_MEMBER ( FDIMENSIONID );

 /**IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_FPM_MAINENTRYID') CREATE INDEX IDX_FPM_MAINENTRYID ON T_FPM_REPORTDATADETAIL ( FMAINDIMDATAID ); **/

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_FPM_FIXDIM') CREATE INDEX IDX_FPM_FIXDIM ON T_FPM_REPORTDATAMAIN ( FORGMEMID ,FCURRENCYMEMID ,FPERIODMEMID ,FSUBJECTMEMID );


/**End D:\softwaresetup\PDM_UPGRADE\PDM1\FPM_constraint.sql **/
