• The only way to know indexes with a partial match are good or not is to evaluate those indexes with your code. There's no way to say for sure based on some formula.

    "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