Post reply

Optimization Task applies to what Indexes

  • December 17, 2004 at 9:27 am

    #163393

    When running the Optimization Task (Reorganize data and index pages) for a Database Maintenance Plan, does the Rebuilding of the Indexes apply only to non-primary key and non-foreign key indexes? Does it apply to the indexes created from defining primary keys and foreign keys?

    Also, when a primary key is defined is the index created a clustered or non-clustered index?

    Thanks in advance, Kevin

     

  • December 20, 2004 at 12:51 pm

    #534527

    See, if this helps:

    http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/ss2kidbp.mspx

    For your second question: SQL Server creates a PK as clustered by default. However, you can create the index using the nonclustered keyword explicitely, if you don't want this.

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

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

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