Tag

SQL ID

1 views collected around this technical thread.

Aikesheng Open Source Community
Aikesheng Open Source Community
Jul 11, 2024 · Databases

Proper Creation and Verification of Outlines in OceanBase to Stabilize Execution Plans

This article explains how to obtain the SQL ID, create an outline bound to that ID, and correctly verify its effect in OceanBase, highlighting common pitfalls such as using the wrong schema or relying on EXPLAIN, and provides practical code examples for each step.

OceanBaseOutlinePerformance Tuning
0 likes · 8 min read
Proper Creation and Verification of Outlines in OceanBase to Stabilize Execution Plans