OceanBase Query Hints, Outline Plan Binding, and SQL Plan Management
OceanBase uses a cost-based optimizer with hint syntax similar to Oracle. There are key operational details to note:
When executing hinted SQL via MySQL client, connect with -c to avoid client-side stripping of hint comments
Unrecognized server hints are silently ignored instead of throwing errors
Hints only modify optimizer plan generation lo ...
Posted on Sun, 31 May 2026 18:33:41 +0000 by homer.favenir