/**Begin E:\NextERP_PDM\PDM_UPGRADE\PDMS\branch_lastest\pdm\PMS_constraint.sql **/
 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_TABNAME = 'T_SM_SPLENTRY' AND KSQL_INDNAME = 'IDX_SM_SPLENTRY_MATERIALID') CREATE INDEX IDX_SM_SPLENTRY_MATERIALID ON T_SM_SPLENTRY ( FMATERIALID ,FPRICEEFFECTDATE DESC );


/**End E:\NextERP_PDM\PDM_UPGRADE\PDMS\branch_lastest\pdm\PMS_constraint.sql **/
