WITH
Orders the select by the index. (this is probs not needed)
SELECT *
FROM SchemaName.TableName
WITH(INDEX(ix_SchameName_TableName_ColName))
Orders the select by the index. (this is probs not needed)
SELECT *
FROM SchemaName.TableName
WITH(INDEX(ix_SchameName_TableName_ColName))