(Vineet Marwah) As we discussed in the Part 1 of this blog series, index entries with many duplicate keys (or duplicate prefix columns in the index keys) can be compressed making it possible to reduce both the storage overhead and the access overhead for large index range scans or fast full scans.
Read More - Register for Free Membership
SQL Server, Azure SQL Database, Amazon RDS & AWS, Oracle and IBM Help