Post reply

sys.dm_db_xtp_hash_index_stats returns bucket counts for range indexes

  • June 10, 2016 at 5:00 am

    #311067

    Hi,

    I have noticed that sys.dm_db_xtp_hash_index_stats returns information on both hash and range indexes, which, for range indexes, does not make sense.

    Has anyone noticed this behavior?

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

  • July 25, 2016 at 1:38 pm

    #1891914

    I noticed that also when using a columnstore index as a clustered index and a non-clustered Hash Primary Key (for in-memory tables). When using dm_db_xtp_hash_index_stats I get one row for a nonclustered range index and 4 rows for the PK nonclustered index (4.7m rows).

    I too would like to know why I am getting these kinds of results.

    Mike Byrd

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply