We are testing partitioning on a table which contains a datetime column (DateColumn).
Partition function I am using is:
-- 138623 + 16774 records
CREATE PARTITION FUNCTION pf_TableName_DateColumn (datetime)
AS RANGE LEFT
FOR VALUES ('20160101', '99991231');
- How do I verify that partitioning the table is improving query performance?
- There is one Clustered index on
PARTITION SCHEME
, do remaining non clustered indexes get statistics of partition?
I am testing it by running the same stored procedure with date parameters on two databases (real and replica). One contains a partitioned table (two partitions) whereas the other is simple. Profiler doesn't show any difference in CPU, Duration, Rows, or Reads.