摘要：查看分区范围 SELECT SCHEMA_NAME(t.schema_id) AS SchemaName, t.name AS TableName, i.name AS IndexName, p.partition_number AS PartitionNumber, f.name AS Parti 阅读全文

摘要：使用分区表提高并发能力和查询处理性能（需命中分区） CREATE PARTITION FUNCTION RangePF1 ( INT ) AS RANGE LEFT FOR VALUES (10, 100, 1000) ; SELECT $PARTITION.RangePF1 (1000) ; CR 阅读全文