sqlserver创建普通索引
create index 索引名 on 表名(字段名)
create index INDEX_CARDNO_BS_PAY_LOCAL_HIST on BS_PAY_LOCAL_HIST (CARDNO);
create index INDEX_TRADEDATE_BS_PAY_LOCAL_HIST on BS_PAY_LOCAL_HIST (TRADEDATE);
create index INDEX_VEHICLECODE_BS_PAY_LOCAL_HIST on BS_PAY_LOCAL_HIST (VEHICLECODE);
create index INDEX_CARDNO_TRADEDATE_BS_PAY_LOCAL_HIST on BS_PAY_LOCAL_HIST (CARDNO,TRADEDATE);
create index INDEX_VEHICLECODE_TRADEDATE_BS_PAY_LOCAL_HIST on BS_PAY_LOCAL_HIST (VEHICLECODE,TRADEDATE);