let say that we have a varchar(100) column and a index on that column
in mysql I can set the index length to any number smaller than 100.. if I set the index length to 5 then the index will consider only first 5 characters from each row
Can I set same thing in MSSQL? How?
I don't think there is any index length set up in sql server; it is handled internally by sql server engine.
Wondering what I would do next , when I am done with this one