From the perspective of a professional DBA and Dev, this is useless. First, it is troublesome. Second, it cannot guarantee pulling data correctly. Third, it does not give enough information...

this author has no idea about execution plan. He just checked statistical IO and did not analyse the execution plan.

Select min(field1) from partitionedtable1

The above statement on a partitioned...