Tagged articles

TopSQL

2 articles · Page 1 of 1

May 28, 2025 · Databases

Analyzing and Optimizing Slow OceanBase SQL Queries Using TopSQL and Execution Plan Rewrites

This article investigates a slow OceanBase SQL query by examining CPU and TopSQL metrics, dissecting the execution plan, identifying batch join inefficiencies, rewriting the SQL for better performance, and demonstrating a reduction in execution time from over 2600 seconds to under one second.

Batch JoinOceanBaseSQL optimization

0 likes · 18 min read

Analyzing and Optimizing Slow OceanBase SQL Queries Using TopSQL and Execution Plan Rewrites

Huawei Cloud Developer Alliance

Mar 6, 2024 · Databases

Mastering GaussDB(DWS) TopSQL: Boost Query Performance and Troubleshoot Issues

This article reviews GaussDB(DWS) TopSQL, explaining its purpose, core principles, configurable parameters, system tables, typical real‑time and historical use cases, and practical tips for using TopSQL to monitor, diagnose, and optimize SQL workloads in production environments.

GaussDBPerformance MonitoringTopSQL

0 likes · 8 min read

Mastering GaussDB(DWS) TopSQL: Boost Query Performance and Troubleshoot Issues