Query selection in a partitioned table

Question

I split the table and split by account id. those. also rows with accountid = 1 in section A, and all rows with accountid = 2 will be in section B. so now if I execute a query with the condition accountid = 1 sql server will search only in section A.

Suppose if I add another condition to it, that is, where accountid = 1 and place = "aaa" will this query search only the section or the entire table? Please, help.

Answer 1

He should look only for section A.

You can verify this by looking at the execution plan.