I will be writing this series of articles for the Special Indexes in SQL Server. In this series we will cover following Index –
1. XML Index
2. Full Text Index
3. Spatial Index
4. Columnstore Index
1. If you are reading this article, I am assuming that you know Index basics like type of Index, how it works and their benefits.
2. You are aware of XML data type in SQL Server.