Select query on a partitioned table

Question

Hi,

I have partitioned a table and it has been partitioned according to an account id. ie also rows that have accountid =1 will be in A partition and all rows that have accountid = 2 will be in B partition. so now if i execute a query with where condition accountid =1 sql server will search only in A partition.

Suppose if i add another condition to it ie where accountid=1 and place="aaa" will this query search only A partition or the entire table? Please help.

Answer 1

It should search only partition A.

You can verify this by examining the execution plan.