A sparse index can focus on the portions of the tables that are most frequently used to do the following things.
- Make the costs for maintaining an index proportional to the percent of rows referenced in the index.
- Make request access faster where the resulting sparse index is smaller than a standard join index.
- Reduce the storage requirements for a join index where possible.