View Single Post

   
  #2 (permalink)  
Old 02-29-2008, 05:53 AM
johnbandettini@yahoo.co.uk
 
Posts: n/a
Default Re: Indexes and File groups

Jens

A clustered index is the table (Well not quiet, but close enough). It
is impossible to have a clustered index on a different filegroup from
the data. You can build non-clustered on a seperate filegroup.

I suggest you rebuild your clustered index on your primary filegroup.
Regards

John

Reply With Quote