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);