Index with two columns of table
Database
2
Posts
2
Posters
0
Views
1
Watching
-
Hello, An index is created with two not null columns of table. The index created is a unique non-clustered index. When trying to re-index this field, it takes a couple of hours. Also, do indexes work if there are two columns defined in a index? Thank you and Happy New Year!
-
Hello, An index is created with two not null columns of table. The index created is a unique non-clustered index. When trying to re-index this field, it takes a couple of hours. Also, do indexes work if there are two columns defined in a index? Thank you and Happy New Year!
How big is your table? Yes an index on two columns do work.