partitioned table and indexes

• winston Smith

  SSCoach

  Points: 19500

  More actions

  June 22, 2011 at 4:10 pm

  #243250

  I want to partition a table that already has a number of indexes, clustered and non clustered.

  Do i have to drop all indexes already on the table and create the indexes against the partition scheme?

  If not, what are the reprocussions of having a partitioned table with non partitioned indexes?

• Welsh Corgi

  SSC Guru

  Points: 116520

  More actions

  June 22, 2011 at 4:27 pm

  #1342733

  Refer to Converting a Nonpartitioned Table to a Partitioned Table at the following URL:

  http://sqlserverpedia.com/wiki/Indexing_for_Partitioned_Tables

  For better, quicker answers on T-SQL questions, click on the following...
  http://www.sqlservercentral.com/articles/Best+Practices/61537/

  For better answers on performance questions, click on the following...
  http://www.sqlservercentral.com/articles/SQLServerCentral/66909/