December 17, 2004 at 9:27 am
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 8:00 am
This was removed by the editor as SPAM
December 20, 2004 at 12:51 pm
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 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply