A better way to index text data
Indexing text data (varchar, nvarchar, char, etc) is a good way to make it faster to find the data you are looking for. However these indexes can end up being very hard on the disks behind the index, as well as the memory of the server. This post shows a couple of techniques which can be used to increase index performance which decreasing the storage requirement.
A better way to index text data
Indexing text data (varchar, nvarchar, char, etc) is a good way to make it faster to find the data you are looking for. However these indexes can end up being very hard on the disks behind the index, as well as the memory of the server. This post shows a couple of techniques which can be used to increase index performance which decreasing the storage requirement.