Post reply

Is always NONCLUSTERED COLUMNSTORE INDEX such as NONCLUSTERED INDEX resident in physical memory?

  • October 14, 2015 at 7:29 am

    #305506

    Hi All,

    Is always NONCLUSTERED COLUMNSTORE INDEX such as NONCLUSTERED INDEX resident in physical memory?

  • October 14, 2015 at 7:31 am

    #1833226

    Huh? Don't understand, can you elaborate on your question?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • October 14, 2015 at 7:41 am

    #1833230

    I want create some columnstore index in my DB's tables, but I don’t know which this indexes always resident in physical memory (use my memory or not!), because I do not want my physical memory used by a lot of indexes.

    Note, I have Restriction to use memory.

  • October 14, 2015 at 7:43 am

    #1833231

    They're not memory resident, however like normal tables and indexes they'll be read into memory to be used, as part of the buffer pool.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 4 posts - 1 through 3 (of 3 total)

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