Shows the current hash indexes and the hash index properties. Hash indexes are supported only on In-Memory OLTP (In-Memory Optimization).
The sys.hash_indexes view contains the same columns as the sys.indexes view and an additional column named bucket_count. For more information about the other columns in the sys.hash_indexes view, see sys.indexes (Transact-SQL).
|Applies to: SQL Server ( SQL Server 2014 through current version).|
|Column name||Data type||Description|
|<inherited columns>||Inherits columns from sys.indexes (Transact-SQL).|
|bucket_count||int||Count of hash buckets for hash indexes.
For more information about the bucket_count value, including guidelines for setting the value, see CREATE TABLE (Transact-SQL).
The visibility of the metadata in catalog views is limited to securables that a user either owns or on which the user has been granted some permission.. For more information, see Metadata Visibility Configuration.
SELECT object_name([object_id]) AS 'table_name', [object_id], [name] AS 'index_name', [type_desc], [bucket_count] FROM sys.hash_indexes WHERE OBJECT_NAME([object_id]) = 'T1';