3295
MySQLWARNINGCriticalQuery OptimizationHIGH confidence
Optimizer hint was ignored
Production Risk
Low — warning only; query executes using the optimizer's chosen plan.
How to reproduce
trigger — this will error
trigger — this will error
SELECT /*+ BKA(t1) */ t1.id FROM t1 WHERE t1.id = 1;
expected output
Warning 3295: Hint BKA is ignored.
Fix
Use EXPLAIN to investigate
Use EXPLAIN to investigate
EXPLAIN FORMAT=TREE SELECT /*+ BKA(t1) */ t1.id FROM t1 WHERE t1.id = 1;
Why this works
EXPLAIN shows the actual execution plan and whether the hint was applied.
What not to do
✕
Sources
Official documentation ↗
MySQL 8.0 — 3295 ER_HINT_IGNORED
Content generated with AI assistance and reviewed for accuracy. Found an error? hello@errcodes.dev