Optimized Indexing MS SQL Server 2008

Use the MAXDOP index option in the index statement to optimize the CPI performance on SQL Server 2008. The number of processors that can be used for all query and index operations is set using the Max Degree of Parallelism option, which by default is set to 0. The default option, 0, uses the actual number of
processors installed in the system for parallel execution plans for queries and index operations. When you want to use a specific number of processors for an individual query or index operation, you can use the MAXDOP query hint or index option to provide better control. MAXDOP overrides the settings defined in the Max Degree of Parallelism option. The use of MAXDOP is limited to the execution of a query that contains the MAXDOP query hint or index option. MAXDOP can also be used with online index creation, and allows you to restrict the number of processors in the SQL Server 2008 server to be used in the online index creation. MAXDOP overrides the Max Degree of Parallelism option with index creation as well.