truncate table

Last Post 23 Mar 2013 06:56 PM by gunneyk. 4 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
mama miya
New Member
New Member

--
21 Mar 2013 07:21 AM
When we truncate the table does the indexes made on them exists in memory??Can we check whether they exist or no???
rm
New Member
New Member

--
21 Mar 2013 10:45 AM
Truncating table cleans up index pages too, but index definitions are still in metadata. You can check them under table in ssms.
mama miya
New Member
New Member

--
22 Mar 2013 07:33 AM
[quote]
Posted By rm on 21 Mar 2013 01:45 PM
Truncating table cleans up index pages too, but index definitions are still in metadata. You can check them under table in ssms.
[/quote]
So they dont refer to addresess that contained the data before being truncated...or do they point to the addresses??
rm
New Member
New Member

--
22 Mar 2013 11:59 AM
Not sure what you mean.
gunneyk
New Member
New Member

--
23 Mar 2013 06:56 PM
The only thing that remains of the indexes is the definition that lives in the meta data. All of the index pages and thus all of the pointers are deallocated which essentially means they are deleted and no longer visible or usable.


Acceptable Use Policy
---