oceanbase-sql-optimization
OceanBase SQL Optimization Skill
Expert in SQL query optimization for OceanBase distributed database (MySQL & Oracle modes).
Provides best practices for writing efficient SQL queries, designing effective indexes, analyzing execution plans, and tuning slow queries in OceanBase. This skill covers both MySQL mode and Oracle mode.
Mode-Specific Syntax Guide
While OceanBase uses the same underlying optimizer for both MySQL and Oracle modes, there are important syntax differences:
More from amber-moe/oceanbase-doc-skills
oceanbase-sql-doc
Write and format OceanBase database SQL statement documentation following official style guidelines. Use when creating or editing SQL reference documentation for OceanBase database.
17oceanbase-examples
Create SQL examples for OceanBase documentation with proper formatting, meaningful names, and separated results. Use when writing or reviewing example sections in OceanBase documentation.
16oceanbase-formatting
Apply OceanBase documentation formatting standards including meta tables, notice boxes, spacing, and markdown lint compliance. Use when formatting or reviewing OceanBase documentation.
16oceanbase-syntax
Write SQL syntax definitions for OceanBase documentation. Syntax sections define structure without semicolons, while examples show executable statements. Use when writing syntax sections or reviewing SQL statement documentation.
15oceanbase-schema-design
Schema design best practices for OceanBase database (MySQL & Oracle modes). Covers table design, partitioning strategies, table groups, index design, and schema optimization principles. Activates for schema design, table design, partition design, index design, database design, DDL.
13