Tagged articles

SQL ID

2 articles · Page 1 of 1

Sep 9, 2025 · Databases

Master OceanBase Slow Query Optimization: From Trace IDs to Manual Stats

This article walks through practical techniques for optimizing slow queries in OceanBase, covering essential data collection, distinguishing trace_id, sql_id, and plan_id, handling multiple sql_id scenarios, and manually gathering statistics across versions, with detailed SQL examples, tables, and visual aids.

OceanBasePlan IDSQL ID

0 likes · 27 min read

Master OceanBase Slow Query Optimization: From Trace IDs to Manual Stats

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.

DatabaseOceanBaseOutline

0 likes · 8 min read

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