moosamca
Right there with Babe
Points: 773
More actions
January 19, 2011 at 1:57 pm
#230661
How to enforce partition ID on the select statement. Is there any way that we do it?
gvarol
Say Hey Kid
Points: 676
January 19, 2011 at 2:09 pm
#1275568
You can put the actual values with an IN statement, this will cause partition elimination.
SELECT * FROM MORTGAGE AS m
WHERE PartitionedCol IN(1, 7, 10, ...)
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply