Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
montu
Yak Posting Veteran
60 Posts |
 Posted - 2007-12-18 : 23:02:53
|
| hi alli am under impression that indexes also stored seperately from data and need extra space . when we check in EM Table Info, size over there is just data size or sum of data and indexes. if it is just for data then is there is any space used to store indexes and that space is counted in space used by data base or else where.............. please clear my confusion.............. i am quite new in administartion of SQL Server |
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2007-12-18 : 23:28:45
|
there's not much extra space needed for a clustered index compared to a heap, because a CI says what order the actual data pages of the table come in. the pages of the table and the pages of the CI are one and the same.for a non-clustered index, the size is more or less determined by the size of the keys and included columns in the index, and the number of rows in the table.to get space used by both data and indexes, run this:exec sp_spaceused MyTable to learn more, read the topics under this item in BOL: http://msdn2.microsoft.com/en-us/library/ms187445.aspx
elsasoft.org |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-12-19 : 00:28:27
|
| Or check it in table properties in ssms. |
|
|
|
|
|
|
space required to store indexes