Paolo Vigori

[AdaptiveIndexDefrag] null @DataCompression parameter leads to null @rebuildCommand

2

If @DataCompression is null, according to spec, it should preserve existing compression for an index. Instead when a rebuild or regenerate is needed, the @rebuildCommand evaluate to null after lines...

[AdaptiveIndexDefrag] Index_level filter conflict with @scanMode = DETAILED

1

At lines 1175 and 1188 the filter on index_level = 0 should not be present if @scanMode = DETAILED. I had an index in a table where level 0 showed...