Indexes for Memory-Optimized Tables

  • Evgeny Garaev

    SSCertifiable

    Points: 6750

    Comments posted to this topic are about the item Indexes for Memory-Optimized Tables

  • Stewart "Arturius" Campbell

    SSC Guru

    Points: 71915

    Nice question to end the week on, thanks Evgeny

    ____________________________________________
    Space, the final frontier? not any more...
    All limits henceforth are self-imposed.
    “libera tute vulgaris ex”

  • Mighty

    SSCrazy Eights

    Points: 8849

    Maybe something worth noting: starting from SQL Server 2017, there is not limit anymore on the number of indexes that can be created.

  • Evgeny Garaev

    SSCertifiable

    Points: 6750

    Mighty - Friday, December 1, 2017 8:12 AM

    ...starting from SQL Server 2017, there is not limit anymore on the number of indexes that can be created.

    That is why question is:

    How many indexes can be created on a Memory-Optimized Table if you use SQL Server 2016?

  • George Vobr

    SSCrazy Eights

    Points: 9252

    Hmm... it's not easy, in the DOCS Maximum Capacity Specifications for SQL Server is stated:
    "Indexes per memory-optimized table: 999 starting SQL Server 2017 and in Azure SQL Database, ...",
    which is more likely than unlimited.

  • Sue_H

    SSC Guru

    Points: 90779

    George Vobr - Friday, December 1, 2017 12:27 PM

    Hmm... it's not easy, in the DOCS Maximum Capacity Specifications for SQL Server is stated:
    "Indexes per memory-optimized table: 999 starting SQL Server 2017 and in Azure SQL Database, ...",
    which is more likely than unlimited.

    I think that's an issue with how Microsoft has screwed up  redone the documentation for SQL Server. They have some things specific to 2017 that are listed as applies to 2016 and later. They have a ton of documents on things where it's listed as starting with 2008 even if it was introduced in earlier versions. It's become incredibly difficult to figure out what applies to what version anymore. They took one of the stronger points of the product and turned it into a weakness.
    I'm waiting for clippy to pop up to help me with backups and restores. And totally screw it up. 

    Sue

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

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