Query Produces Different Results with IGNORE INDEX or Different Optimizer Switches
(Doc ID 2751495.1)
Last updated on FEBRUARY 10, 2021
Applies to:MySQL Server - Version 8.0 to 8.0 [Release 8.0]
Information in this document applies to any platform.
A query which involves JOINs produces different results depending on the use of IGNORE INDEX or changing the optimizer_switch variable to enable/disable mrr, mrr_cost_based, or batched_key_access.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document