• I might have misunderstood, but selectivity matters just as much in a clustered index. The same b-tree structure sits on top of the pages, controlling access and determining if you're getting seeks or scans, just like with a non-clustered index. I wouldn't deemphasize the importance of selectivity in the cluster. But, as I said, maybe I misunderstood.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning