Home Forums Article Discussions Article Discussions by Author Discuss content posted by Raj Gujar Moving Large Table to Different File Group RE: Moving Large Table to Different File Group

  • October 16, 2008 at 2:21 am

    #885676

    jayant (10/16/2008)

    I think my question is little confusing, let me make it more clear

    If we have a table with cluster index then by simply recreating the clustered index on different file group will move the table also on that file group

    now I have a table with no index (for simplicity) and I would like to move that table to a newly created filegroup, how would I do that?

    Not sure I understand how not having a clustered index makes things simpler. Every table should have a clustered index. I would suggest creating a clustered index which would then move your data to the new filegroup.

    If you really really don't want the index you can drop it again - however a clustered index does not add any overhead to the table so you should definitely have one.