May 7, 2007 at 1:18 pm
I'm about to convert a text column to XML, and create one primary XML index and one secondary XML index. The database size doing this goes from about 6 GB to around 25 GB. So my thinking was put the XML index on a different file group on a seperate portion of the SAN I got.
Reading up on this in the BOL under the Create Index header, it says "
Creates the specified index on the specified filegroup. If no location is specified and the table or view is not partitioned, the index uses the same filegroup as the underlying table or view. The filegroup must already exist. XML indexes use the same filegroup as the table.
"
Emphasis mine. Does that mean that an XML index can only be on the same filegroup as the table, or that that is the default filegroup?
May 8, 2007 at 6:37 am
It appears to me that xml indexes cannot be put to a different filegroup from the underlying table, if the table is partitioned ( over filegroups ) then the index will follow - indexes on partitioned tables are usually best in the same partition.
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply