filegroups and index

If i create indexes on say filegroupA that spans the X drive and create
tables on say filegroupB that spans the Y drive and if i have a clustered
index, what gets stored on FGA and what on FGB.
Does the leaf level of the Clustered index which are the data pages get
stored on FGB and does the non leaf level get stored on FGA ? and if they
are on 2 different drives or physical arrays, whats the performance impact ?
Please help me understand this
Thank youHassan
You can not seperate your table and a clustered index, you
can put non-clustered indexes in a seperate file group. If
you put a table in one filegroup, the clustered index (all
levels) will be in the same filegroup.
Regards
John
>--Original Message--
>If i create indexes on say filegroupA that spans the X
drive and create
>tables on say filegroupB that spans the Y drive and if i
have a clustered
>index, what gets stored on FGA and what on FGB.
>Does the leaf level of the Clustered index which are the
data pages get
>stored on FGB and does the non leaf level get stored on
FGA ? and if they
>are on 2 different drives or physical arrays, whats the
performance impact ?
>Please help me understand this
>Thank you
>
>.
>