Allow Ignore for OPTIMIZE FOR clauses
In single-tenant database environments with multiple databases sharing similar schemas, OPTIMIZE FOR clauses can be used to prevent query plan regressions. However, database object comparison tools should include an option to ignore these clauses, since optimisation parameters that work for one database may not be suitable for other single-tenant databases.
3
votes
