I'm trying to evaluate the impact of a new index on various queries that run against a DB2 11.1 database.
It would be convenient to be able to force the optimizer to ignore the new index on a query-by-query basis. Oracle would let me do this through optimizer hints, for example
The convenience comes from not having to delete and re-create alternative indexes when comparing their effects on a query, from not requiring "stateful" configuration changes that you must remember to revert, and from avoiding interference with other users' queries.
Is there an analogous mechanism in DB2 for that?