MySQL 8.0.20 and above uses Index Optimizer Hints, and table hints are deprecated.
The optimizer hint syntax /*+ INDEX(table idx) */ does not work with this extension because the text within the // characters does not make it from the editor window to the optimizer.
MySQL 8.0.20 and above uses Index Optimizer Hints, and table hints are deprecated.
The optimizer hint syntax
/*+ INDEX(table idx) */does not work with this extension because the text within the / / characters does not make it from the editor window to the optimizer.