• A query is not selective or not. The data it is accessing may or may not be selective. I don't understand where you're trying to go with this.

    You can query statistics and indexes to determine the selectivity of the underlying data. Is that what you're looking for?

    "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