Query for Rebuild all Indexes with update statistics of Database at Single Click?

Question

Hi All,

Can you please help me to add update statistics to below script . need deploy on Azure Pass environment

DECLARE @TableName VARCHAR(255)

DECLARE @sql NVARCHAR(500)

DECLARE @fillfactor INT

SET @fillfactor = 80

DECLARE TableCursor CURSOR FOR

SELECT OBJECT_SCHEMA_NAME([object_id])+'.'+name AS TableName

FROM sys.tables

OPEN TableCursor

FETCH NEXT FROM TableCursor INTO @TableName

WHILE @@FETCH_STATUS = 0

BEGIN

SET @sql = 'ALTER INDEX ALL ON ' + @TableName + ' REBUILD WITH (FILLFACTOR = ' + CONVERT(VARCHAR(3),@fillfactor) + ')'

PRINT (@sql)

EXEC (@sql)

 

FETCH NEXT FROM TableCursor INTO @TableName

END

CLOSE TableCursor

DEALLOCATE TableCursor

Answer 1

Hi,

Since you are using Alter index with option All, so per below link you need not update statistics separately:

https://techcommunity.microsoft.com/t5/sql-server-support-blog/does-rebuild-index-update-statistics/ba-p/318521#:~:text=If%20someone%20asks%20you%20the%20question%20%E2%80%9CDoes%20rebuild,to%20illustrate%20this%20better%2C%20let%E2%80%99s%20draw%20a%20table

Regards,