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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Table Index Storage Space

Author  Topic 

SQL_ACTUARY
Starting Member

7 Posts

Posted - 2007-02-21 : 15:42:02
Hi,

Where is a table index stored on the disk relative to other Database components? I thought that by adding an index, the table size increased only. I am being told that our server is running out of table index storage space, but I thought the table and index were stored together. Is there a separate index space storage allocation for Sql Server 2000?

Any link to official documentation would be helpful. Thanks

jezemine
Master Smack Fu Yak Hacker

2886 Posts

Posted - 2007-02-23 : 13:06:32
depending on what filegroup the index was created on, it could be in the same file as the table data, or in a different file. it could even be on a different disk.

about create index: http://msdn2.microsoft.com/en-us/library/ms188783.aspx

about filegroups: http://msdn2.microsoft.com/en-us/library/ms179316.aspx

www.elsasoft.org
Go to Top of Page
   

- Advertisement -