Applies To: SQL Server 2014, SQL Server 2016 Preview
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).
Inherits columns from sys.indexes (Transact-SQL).
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.