Home Forums SQL Server 2005 Administering Query to find maxdop of an index RE: Query to find maxdop of an index

  • September 19, 2014 at 1:43 am

    #1746605

    pawana.paul (9/19/2014)

    Hello,

    I altered index with maxdop to somevalue (n). What is the query to validate that xyz index has maxdop value set to (n)?

    I tried with GUI. index properties, option and see set maxdop value is 0.

    Regards,

    It is under the Option page of the Index Properties.

    😎