736      阿裏雲  技術社區[雲棲]

SqlServer 表分區信息

USE Test2; --Do
GO
--查詢分區函數

SELECT *
FROM sys.partition_functions;
--查看分區架構

SELECT *
FROM sys.partition_schemes;


--查看分區信息

DECLARE @tableName VARCHAR(100);
SET @tableName = 'Sales'; --Do

SELECT CONVERT(VARCHAR(50), ps.name) AS partition_scheme,
       p.partition_number,
       CONVERT(VARCHAR(10), ds2.name) AS filegroup,
       CONVERT(VARCHAR(19), ISNULL(v.value, ''), 120) AS range_boundary,
       STR(p.rows, 9) AS rows
FROM sys.indexes i
     JOIN sys.partition_schemes ps ON i.data_space_id = ps.data_space_id
     JOIN sys.destination_data_spaces dds ON ps.data_space_id = dds.partition_scheme_id
     JOIN sys.data_spaces ds2 ON dds.data_space_id = ds2.data_space_id
     JOIN sys.partitions p ON dds.destination_id = p.partition_number
                              AND p.object_id = i.object_id
                              AND p.index_id = i.index_id
     JOIN sys.partition_functions pf ON ps.function_id = pf.function_id
     LEFT JOIN sys.partition_range_values v ON pf.function_id = v.function_id
                                               AND v.boundary_id = p.partition_number - pf.boundary_value_on_right
WHERE i.object_id = OBJECT_ID(@tableName)
      AND i.index_id IN(0, 1)
ORDER BY p.partition_number;

最後更新：2017-11-04 22:03:45

  上一篇：  Hbase客戶端優化

  下一篇：  Hbase行健設計原則