Do we have to run auto update statistics after index rebuild?

I want to rebuild one of my indexes because fragmentation has reached 97 percent.

I want to know if after I rebuild my index, do I have to update the statistics as well? My auto update statistics feature is on.

And is it necessary to do the auto update?

You should not update statistics after you rebuilt the index as rebuilding it gives you up-to-date statistics. See Does rebuild index update statistics? by Jack Li for more info.

You get updated stats for the specific index you just rebuilt. Other stats for other indexes on the same table (and statistics not associated with an index at all) do not get updated. You may or may not choose to update those stats separately.

Auto-update is recommended, though I would also recommend a scheduled job too as the threshold for when auto-update kicks in can be too high for many systems. I usually have an update stats job run daily or even more frequently, but it depends on the system and its needs.

StackExchange Database Administrators Q#158760, answer score: 5