sql server (alternate): move indexes via ALTER INDEX -- sql server (alternate)

move indexes via ALTER INDEX

rcamarda
3/12/2007 7:23:04 PM

sql server (alternate): I was checking out an indexes property via SQL 2005 Management Studio
and it looks like I can move the index to other filegroups via the
drop down.
I checked the BOL ALTER INDEX and I didnt see an argument for this
action. I see stuff about PARTITION, but I think that is for row
partitioning??
I want to move existing indexes from the PRIMARY filegroup to a new
file group just for indexes, which is called INDEXES.
Can this be done via ALTER INDEX or some other way?
TIA
Rob

Re: move indexes via ALTER INDEX

Paul S. Randal [MS]
3/12/2007 11:32:04 PM

Check out the CREATE INDEX ... WITH DROP_EXISTING syntax where you specify
the filegroup to create the new index on.

--
Paul Randal
Principal Lead Program Manager
Microsoft SQL Server Core Storage Engine,
http://blogs.msdn.com/sqlserverstorageengine/default.aspx

[quoted text, click to view]