Post reply

how much space does index creation use

  • June 29, 2012 at 12:58 pm

    #263095

    I created an index on a table which has around 50 million records....but looks like index creation took close to 2 GB space.....Does it take usually take so much of space?? what does sql server do with this space?? Is it stored in Data files???

  • June 29, 2012 at 1:31 pm

    #1507292

    this must be a non-clustered index, how much space it will take is dependant on the columns that make up the index, no of rows in the table and padding factors.

    Indexes are stored along withe the data, you can specify which filegroup in the database they will be stored in (on a per index basis)

    ---------------------------------------------------------------------

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

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