SQL Server Performance

Adding new indexes to partitioned tables

Discussion in 'SQL Server 2005 General DBA Questions' started by scottrcaldwell, Nov 17, 2008.

  1. scottrcaldwell New Member

    Do you need to specifiy the partition scheme and partition id when adding a new unclustered index to a partitioned tabled? I always thought SQL Server took care of this for you.
    Thanks,
    Scott
  2. satya Moderator

Share This Page