Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by Solomon Rutzky Improving Performance of Cross-Partition Queries RE: Improving Performance of Cross-Partition Queries
matlani.dhiraj
SSC Rookie
Points: 28
More actions
May 5, 2010 at 12:14 am
#1162249
How about this query ?
SELECT MIN(etp.IntDate)
FROM dbo.ExampleTablePartitioned etp
WHERE etp.PartitionID in (1,2,3,4,5,6,7,8,9,10)
Will we get the performance as good as the case when we didn't have any partition ?