set table used index in ms sql server code example Example: sql create index CREATE INDEX index_name ON tableName (tableColumn);