ms-sql 資料表建索引

參考:
CREATE INDEX index_name
ON table_name (column_name1, column_name2···);

DROP INDEX table_name.index_name;

select * from sys.indexes

範例:
if not exists(select name from sys.indexes where name='IX_OXX')
begin
  CREATE INDEX IX_OXX
  ON CUSTXX (A1,A2,A3,A4)
end