Home > Posts > SQL Server Index Selectivity

Download selectivity.sql (Right Click->Save Target As...).

This script calculates the selectivity of values in a column in a SQL Server table to show usefullness of an index. The script uses a table in Adventure Works Light database as an example.

Please send any questions or comments to Bruce Dunwiddie.