how does SQL-Server 2005 behave when i run parameterized queries on a partitioned table?
does the partition pruning mechanism still work or do i need to do something so that the pruning mechanism will continue to work?
for example :
the table RECORDS has four columns :
and is partitioned by the column customer_id.
if i'll issue the query :
select * from RECORDS where customer_id = : x;
will SQL-Server access all partitions or will it access only the needed partition?
if the first option is true, how can i make it access only the needed partition?
any information on that matter will help.
thanks is advance,