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 |
|
purdyra
Starting Member
7 Posts |
 Posted - 2014-01-09 : 11:11:08
|
| if i have a large table 150 gb and i create a clustered index, does sql create another copy of that table (so in reality i have another table thats just as big) but now its sorted a certain way?if i create a non-clustered index, it seems like the size is 1/6 of the size, so does it just create a pointer table behind the scenes, which of course takes up space as well on the DB.thanks for your help. |
|
|
denis_the_thief
Aged Yak Warrior
596 Posts |
Posted - 2014-01-09 : 11:40:29
|
| That's true, a non-clusted index should be smaller than the entire table. It does not store all columns, just the index columns and the leaf nodes contain pointers to the table records.If I'm not mistaked, the size of the clustered index includes the size all the data of the actual table as well. |
 |
|
|
|
|
|
index maintenance