/**Begin E:\NextERP_PDM\PDM_UPGRADE\PDMS\branch_lastest\pdm\SM_constraint.sql **/
 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SM_SOE_FOWNERID') CREATE INDEX IDX_SM_SOE_FOWNERID ON T_SM_SALORDERENTRY ( FOWNERID );

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SM_SALORDER_FBIZDATE') CREATE INDEX IDX_SM_SALORDER_FBIZDATE ON T_SM_SALORDER ( FBIZDATE  DESC );


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