• 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 ?