It should only access the partition where the data resides. Yo should be able to verify this by having SSMS show you the actual execution plan when running the query.