Home Forums SQL Server 2008 SQL Server 2008 - General Truncate table RE: Truncate table

  • March 25, 2013 at 7:49 am

    #1600319

    Sean Lange (3/21/2013)

    mehta.saurabhj (3/21/2013)

    tim_harkin (3/21/2013)

    If you are talking about the index definitions, then yes they are still there. Index data is gone - their pages are deallocated as well.

    I mean to say that suppose it i create a non clustered index on column 'name' and then when i truncate the table then will this index remain in memory..or not??? That is will the key and value pair as in case of hash tree will remain or not??

    Yes the index will remain on the table. I still don't understand what you mean about in memory.

    Clustered indexes are stored within the referenced table and not in memory. Memory is volatile so if the indexes were stored there they would have to rebuilt every time the server was started anew!