• You can view the execution plan in SSMS for the query and see the order in which things are applied. The short answer is "it depends". The optimizer will consider # of records, based on statistics, and indexes and it could do either one first.

    The way you write it is irrelevant.