To set Best Practices statistics options
Click in the main menu.
Select Optimize SQL | Best Practices | Plan.
Review the following for additional information:
Threshold for small table with full table scan when it has fewer blocks than |
Enter a table size in blocks that you want defined as a small table. Best Practices recommends you keep a table in cache with fewer blocks than the value you enter. Default: 10 |
Warning for large table scan with full table scan when it has more blocks than |
Enter a table size in blocks that you want defined as a large table. Best Practices recommends you optimize SQL statements that perform a full table scan on a table with more blocks than the value you enter. Default: 200 |
To specify options for Batch Optimize SQL
Click in the main menu.
Select Batch Optimize SQL | Options.
Specify options to use when Batch Optimize SQL optimizes your SQL statements. Review the following options which are organized by optimization step.
Step |
Options |
1. Search for SQL statements in your code | |
|
Automatically start extracting SQL when job is added
|
2. Optimize the SQL statements found by generating different alternatives | |
|
SQL to automatically optimize
|
3. Execute the alternatives to determine the best replacement SQL | |
|
Types of SQL statements to execute automatically after optimization
Note:Batch Optimize SQL also executes the SQL alternatives of the statement types you select. |
SQL with bind variables:
See Set Bind Variables (Batch Optimize) for additional information. |
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Términos de uso Privacidad Cookie Preference Center