Posted by Erland Sommarskog on 11/30/05 14:01

Dr Warehouse (d.riebeek@reddion.com) writes:
> Thanks. Nonclustered indexes are already on seperate filegroups. Do you
> know wat the difference in locking / performance gain is if the table
> structure stays on the 'old' filegroup (in case of an clustered index
> to a new filegroup) or the table structure is on the new filegroup.

The clustered index is the the table structure, so if you move the
clustered index, there will be nothing left on the old filegroup.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: Re: Clustered versus Create table on high speed FILEGROUP
• Prev in forum: Re: Clustered versus Create table on high speed FILEGROUP
• Thread view: Re: Clustered versus Create table on high speed FILEGROUP

[Reply to this message]