Post reply

Interaction between partioned tables and partioned indexes

  • February 11, 2009 at 3:46 am

    #130843

    Scenario: A partioned table has a partioned index both using the same partioned-function but with different partioned-schemes due to the index being in a different filegroup (physical disc) to that of the table.

    When performing an "alter table switch" to dump out a partion, how efficient is SQL Server in removing the associated partion from the index?

  • March 6, 2009 at 3:38 am

    #954733

    Partition switching is a schema-only operation - i.e. only the pointers to the actual physical location of data are changed, no data is actually moved.

    However, indexes must be aligned with table partitions for the operation to succeed - both on the source table as well as the target table.

    What exactly do you mean by "efficient"?

    ML

    ---
    Matija Lah, SQL Server MVP
    http://milambda.blogspot.com

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply