About Generating Index Alternatives
SQL Optimizer analyzes the following in your original SQL statement and table references to generate index alternatives:
- SQL statement syntax
- Related tables and indexes
- Search arguments
- Table join conditions
Once SQL Optimizer generates alternatives, you can test them to evaluate improvements in database performance.
Note: SQL Optimizer does not physically create indexes on your database when generating alternatives.
Related Topics