Problem with index filegroup
-
Hi,
i don't know if there are already a topic for this problem...
I have a database with 2 partitions,
PRIMARY and INDEX
the filegroup of PRIMARY is on drive (D
, while the filegroup of INDEX is on drive (E.My goal is to put data on [PRIMARY] and index on [INDEX]
.My actions:
CREATE
TABLE dbo.table1
(
[field1] [int],
[field2] [varchar],
[field3] [varchar]
)
ON [PRIMARY]
and here is ok
after i create
the index
ALTER
TABLE dbo.table1 ADD CONSTRAINT [PK_TABLE1] PRIMARY KEY CLUSTERED
(
[field1] asc,
[field2] asc
)
WITH (PAD_INDEX = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF) ON [INDEX]
but this operation, move also table1 object from filegroup [PRIMARY] to file group [INDEX].
I can keep the index on [INDEX] and the table on [PRIMARY] ?
if is possible how i can?
thanks for help!
Aldo
-
SORRY for post...
i have found the answer to http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=149&messageid=340948#bm341421
tnx
-
Hi Friend,
By default Primary key creation clustered index and you are placing the clustered index on the another file group, as the clustered index moves the data and index keys to the same location your table file groups should also got changed,
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply