浪潮数据库优化

CREATE NONCLUSTERED INDEX KCCKD2_LSBH_1 ON lc0019999.KCCKD2
(
    KCCKD2_LSBH,
    KCCKD2_WLBH,
    KCCKD2_PCH ,
    KCCKD2_HWBH ,
    KCCKD2_WLZT ,
    KCCKD2_WLBZ ,
    KCCKD2_TSKC ,
    KCCKD2_XGDX ,
    KCCKD2_ZYX1 ,
    KCCKD2_ZYX2 ,
    KCCKD2_ZYX3 ,
    KCCKD2_ZYX4 ,
    KCCKD2_ZYX5 ,
    KCCKD2_JE 
);

CREATE NONCLUSTERED INDEX KCRKD2_LSBH_1 ON lc0019999.KCRKD2
(
    KCRKD2_LSBH,
            KCRKD2_WLBH ,
            KCRKD2_PCH ,
            KCRKD2_HWBH ,
            KCRKD2_WLZT ,
            KCRKD2_WLBZ ,
            KCRKD2_TSKC ,
            KCRKD2_XGDX ,
            KCRKD2_ZYX1 ,
            KCRKD2_ZYX2 ,
            KCRKD2_ZYX3 ,
            KCRKD2_ZYX4 ,
            KCRKD2_ZYX5 ,
            KCRKD2_SSSL ,
            KCRKD2_FSSSL1 ,
            KCRKD2_FSSSL2 ,
            KCRKD2_JE 
);

 

CREATE NONCLUSTERED INDEX [KCCKYE_MAX_KJNDQJ] ON [lc0019999].[KCCKYE]
(
    [KCCKYE_KJND] DESC,
    [KCCKYE_KJQJ] DESC,
    [KCCKYE_SLYE] ASC
)