Home Forums SQL Server 2005 Administering prefixing indexes RE: prefixing indexes
whitlander
SSChasing Mays
Points: 637
More actions
March 10, 2011 at 9:40 am
#1297182
when creating an index you can filter the index key to read only N number of characters in field e.g abcdefg and not abcdeftgghhjjjjjjjjjjjjjjjjjjjjjjjjjj. I understand that when the field is used in a query there is less of an overhead.