-- 批号序列号最大流水号表添加索引
IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IX_LOTMAX_RULEMATPROP') CREATE INDEX IX_LOTMAX_RULEMATPROP ON T_BD_LOTMAXSERIAL (FLOTCODERULEID,FMATERIALID,FACCORDPROP);