Reorg job updating stats

[teknogrl]

Hello,
We are using your reorg/reindex jobs in production. I have the following set up, which I believe means it would not update stats, however in the commandlog table I'm seeing a rebuild of the index immediately following the reorg of the index, screen shot attached. Am I misunderstanding the use of the word NULL on update stats?

EXECUTE [dbo].[IndexOptimize]
@databases = 'DATABASENAME',
@indexes = 'DATABASENAME.dbo.%',
@LogToTable = 'Y',
@LOBCompaction = 'N',
@FragmentationMedium = 'INDEX_REORGANIZE',
@FragmentationHigh = NULL,
@UpdateStatistics = NULL

[BHubartt38]

I would suggest commenting out or removing the parameter @UpdateStatistics.

I can't remember exactly where I read it, but I created a separate job to update statistics for better control.

You can try the following. If you want to test you can change @LogToTable and @execute to 'N' to see what will be executed.
-- Statistics Only
EXECUTE dbo.IndexOptimize
@databases = @DatabasesToBackup,
@FragmentationLow = NULL,
@FragmentationMedium = NULL,
@FragmentationHigh = NULL,
@UpdateStatistics = 'ALL',
@OnlyModifiedStatistics = 'Y',
@LogToTable = 'Y',
@execute = 'Y'

-- Indexes Only
EXECUTE dbo.IndexOptimize
@databases = @DatabasesToBackup,
@FragmentationLow = NULL,
@FragmentationMedium = 'INDEX_REORGANIZE,INDEX_REBUILD_ONLINE',
@FragmentationHigh = 'INDEX_REBUILD_ONLINE',
@LogToTable = 'Y',
@execute = 'Y';

[teknogrl]

Thanks for the response, the job actually had the updates stats excluded, and we were still seeing update stats happening, (and being logged to hte table) so I updated the job to include the update stats but with the NULL value. Any other thoughts?

[BHubartt38]

Hmmm...strange...

...but, I think the reason is tied to @fragmentation<Low/Medium/High>

If you do a text search of the procedure for "Update statistics?", so somewhere around line 2015, there is some logic that sets the parameter @CurrentUpdateStatistics. I'm running Enterprise edition so I'm able to use INDEX_REBUILD_ONLINE which causes @CurrentUpdateStatistics to be set to 'N' which I think does not do a statistics update after the index update.