To set general best practices options
Click in the main menu.
Select Optimize SQL | Best Practices | General.
Display Best Practices tab in SQL Rewrite mode |
Select to display the Best Practices tab. Note: Best Practices is only available for SQL Rewrite session in Optimize SQL. |
To set Best Practices table options
Click in the main menu.
Select Optimize SQL | Best Practices | Table.
Review the following for additional information:
Checked for chained rows |
Click and select whether to check tables for chained rows. Default: Ignore |
Ratio of smallest partition to the largest partition is less than (%) |
Enter a percentage for the ratio of the smallest partition to the largest partition in a table. Default: 40% Note: The value you enter determines whether Best Practices recommends you change the partitioning size setting. |
To set Best Practices index options
Click in the main menu.
Select Optimize SQL | Best Practices | Index.
Review the following for additional information:
Determine selectivity when there are no statistics |
Select one of the following:
Default: Compute |
Compute selectivity by sampling (%) |
Enter the percentage of data to use for calculating selectivity. Default: 0.10% Note: This value is used when you select Compute or Compute All for calculating selectivity. |
Determine if index tree is unbalanced |
Click and select whether to check for unbalanced index trees. Default: Ignore |
To set Best Practices statistics options
Select Optimize SQL | Best Practices | Statistics.
Review the following for additional information:
Warning for stale statistics when data changes are greater than (%) |
Enter the percentage of data that must be modified since the last statistics update to generate a warning message to update statistics. Default: 10% |
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Conditions d’utilisation Confidentialité Cookie Preference Center