drop index u_smshis.ix_usmshis_cstime
go
create nonclustered index ix_usmshis_cstime on u_smshis(create_time desc)
go
drop index u_smshis.ix_usmshis_hza
go
create nonclustered index ix_usmshis_hza on u_smshis(corp_id, sms_status)
go
drop index u_smshis.ix_usmshis_hzb
go
create nonclustered index ix_usmshis_hzb on u_smshis(corp_id, send_time, sms_feeczstatus, sms_feecztime)
go
drop index SF_FEERECS.ix_SF_FEERECS_homecxa
go
create nonclustered index ix_SF_FEERECS_homecxa on SF_FEERECS(CORP_ID, GARD_ID, PAY_TIME)
go
drop index SF_FEERECS.ix_SF_FEERECS_homecxb
go
create nonclustered index ix_SF_FEERECS_homecxb on SF_FEERECS(CORP_ID, GARD_ID, PAY_TIME, FEE_TYPE)
go
drop index SF_FEEFPH.ix_SF_FEEFPH_homecxa
go
create nonclustered index ix_SF_FEEFPH_homecxa on SF_FEEFPH(CORP_ID, GARD_ID, PAY_TIME)
go
/*收费管理-收费流水号历史 索引*/
drop index SF_FPHHIS.ix_SF_FPHHIS_mxcxa
go
create nonclustered index ix_SF_FPHHIS_mxcxa on SF_FPHHIS(FPHH_TIME desc)
go
/*收费管理-收费明细按截止日期 索引*/
drop index SF_FEERECS.ix_SF_FEERECS_endtimedesc
go
create nonclustered index ix_SF_FEERECS_endtimedesc on SF_FEERECS(CORP_ID, GARD_ID, RM_ID, FEE_NO,END_TIME desc)
go
/*财务统计-应收明细、房间费用明细等 索引*/
drop index SF_FEERECS.ix_SF_FEERECS_mxcxa
go
create nonclustered index ix_SF_FEERECS_mxcxa on SF_FEERECS(CORP_ID, GARD_ID, RM_ID, FEE_NO,START_TIME)
go
/*财务统计-收支明细统计、优惠明细、滞纳金明细 索引*/
drop index SF_FEERECS.ix_SF_FEERECS_mxcxb
go
create nonclustered index ix_SF_FEERECS_mxcxb on SF_FEERECS(CORP_ID, GARD_ID, RM_ID, FEE_NO,PAY_TIME desc)
go
/*财务统计-收支流水统计 索引*/
drop index SF_FEEFPH.ix_SF_FEEFPH_listcxa
go
create nonclustered index ix_SF_FEEFPH_listcxa on SF_FEEFPH(CORP_ID,PAY_TIME desc)
go
