UPDATE STATISTICS On Azure SQL DB

Question

How to run UPDATE STATISTICS on entire DB in Azure SQL DB.

Answer 1

My suggestion is to use Ola Hallengren scripts as shown below. Based on my own experience, updating statistics and defragmentation of indexes are very important for Azure SQL performance and to save money on Azure SQL.

EXECUTE dbo.IndexOptimize
@Databases = 'Alchavo30',
@FragmentationLow = NULL,
@FragmentationMedium = NULL,
@FragmentationHigh = NULL,
@UpdateStatistics = 'ALL',
@OnlyModifiedStatistics = 'Y'
GO

Answer 2

Hi,

Basically it is done like SQL Server On-Premises

TO update all statistics use:

EXEC sp_updatestats;  

And to update specific table you use:

UPDATE STATISTICS Sales.SalesOrderDetail;    

For full examples and explanation you can check the official documentation here:

https://learn.microsoft.com/en-us/sql/t-sql/statements/update-statistics-transact-sql?view=sql-server-ver15&WT.mc_id=DP-MVP-5001699#next-steps