Description of the feature
[It can be a new feature, or a change to an existing feature]
Date: February 18, 2026.
SQL auto updates statistics during the day on large tables. Auto update statistics uses a sample rate less than 1% so several SQL queries change to inefficient execution plans. We need to update statistics setting a persistent sample rate of 10% or 20%.
Example:
update statistics tablename with sample 10 percent, persist_sample_Percent = On
Ola can you please add this as an option to your IndexOptimize update statistics commands?
Microsoft documentation for option to set persistence during update statistics:
https://learn.microsoft.com/en-us/sql/t-sql/statements/update-statistics-transact-sql?view=sql-server-ver17
Thank you! Keep up the great work. These are excellent SQL maintenance plans.
Jim Rainville
Email = jim.rainville@gehealthcare.com
Description of the feature
[It can be a new feature, or a change to an existing feature]
Date: February 18, 2026.
SQL auto updates statistics during the day on large tables. Auto update statistics uses a sample rate less than 1% so several SQL queries change to inefficient execution plans. We need to update statistics setting a persistent sample rate of 10% or 20%.
Example:
update statistics tablename with sample 10 percent, persist_sample_Percent = On
Ola can you please add this as an option to your IndexOptimize update statistics commands?
Microsoft documentation for option to set persistence during update statistics:
https://learn.microsoft.com/en-us/sql/t-sql/statements/update-statistics-transact-sql?view=sql-server-ver17
Thank you! Keep up the great work. These are excellent SQL maintenance plans.
Jim Rainville
Email = jim.rainville@gehealthcare.com