server icon indicating copy to clipboard operation
server copied to clipboard

Published 20 hours ago • verified publisher icon MariaDB

MDEV-36106 New-style hints: [NO_]DERIVED_CONDITION_PUSHDOWN, [NO_]MERGE

Open DaveGosselin-MariaDB opened this issue 8 months ago • 10 comments
trafficstars

Implements and tests the following optimizer hints:

  • DERIVED_CONDITION_PUSHDOWN
  • NO_DERIVED_CONDITION_PUSHDOWN
  • MERGE
  • NO_MERGE

Each of these are table-level hints. The first pair enable and disable, respectively, the condition pushdown for derived tables which is typically controlled by the condition_pushdown_for_derived optimizer switch. The second pair enable and disable, respectively, the derived table merge optimization which is typically controlled by the derived_merge optimizer switch.

DaveGosselin-MariaDB avatar Mar 05 '25 19:03 DaveGosselin-MariaDB