Rebuild index frequency/schedule and delay?

Duchemin, Dominique 2,006 Reputation points


  1. How often do you run the rebuild index on the SQL MEMCM Database CM_UCP?
  2. How long does it run?
  3. do you use?

EXECUTE dbo.IndexOptimize
@Databases = 'USER_DATABASES',
@FragmentationLow = NULL,
@FragmentationLevel1 = 5,
@FragmentationLevel2 = 30,
@UpdateStatistics = 'ALL',
@OnlyModifiedStatistics = 'Y'

  1. or another script/job?


SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,597 questions
Microsoft Configuration Manager
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Garth 5,801 Reputation points
    1 person found this answer helpful.
    0 comments No comments