Indexes On Filegroups

Hi All,
I'm splitting a large database into filegroups. Files that join each other
are put in different filegroups to eliminate contentions.
Is it advisable to create Clustered indexes on different filegroup and not o
n
the base table filegroup.? I know it can be done on nonclustered indexes.
Thanks.
Message posted via http://www.webservertalk.comIf I understand you correctly, it cant be done. Clustered indexes need to be
on the sam filegroup as the table they are on. On SQL Server 2005 things are
slightly different, partitions need to be on the same FG.
MC

>"Naana via webservertalk.com" <u14055@.uwe> wrote in message
>news:5fa683e03f6c5@.uwe...
> Hi All,
> I'm splitting a large database into filegroups. Files that join each other
> are put in different filegroups to eliminate contentions.
> Is it advisable to create Clustered indexes on different filegroup and not
> on
> the base table filegroup.? I know it can be done on nonclustered indexes.
> Thanks.
> --
> Message posted via http://www.webservertalk.com|||Clustered indexes are not seperately stored. Its the order in which the
actual table is stored physically (for all practical purposes). So you can't
seperate the cluster index from the table in this version or SQL Server and
any newer versions. Hope this helps.
--
"Naana via webservertalk.com" wrote:

> Hi All,
> I'm splitting a large database into filegroups. Files that join each other
> are put in different filegroups to eliminate contentions.
> Is it advisable to create Clustered indexes on different filegroup and not
on
> the base table filegroup.? I know it can be done on nonclustered indexes.
> Thanks.
> --
> Message posted via http://www.webservertalk.com
>|||Yes, it does help.
Thanks.
Omnibuzz wrote:
>Clustered indexes are not seperately stored. Its the order in which the
>actual table is stored physically (for all practical purposes). So you can'
t
>seperate the cluster index from the table in this version or SQL Server and
>any newer versions. Hope this helps.
>[quoted text clipped - 5 lines]
Message posted via webservertalk.com
http://www.webservertalk.com/Uwe/Forum...amming/200605/1