sql server - Select query on a partitioned table -

I split a table and it has been divided according to account id. That is, in those lines, accountcid = 1 will be split, and in all rows, accountcid = 2 will be divided into binary. So now if I execute a query where the condition accountcid = 1 sql server will only search in one partition.

Suppose I add another condition for that, i.e. where accounted = 1 and location = "AAA" will be query only search a partition or full table? help please.

It should only search for partition A.

You can verify it by checking the execution plan.