How can I locate distributed SQL statements in a tenant?

2024-03-22 09:34:34  Updated

OceanBase Database is a distributed database that allows you to distribute data read and write services to all servers in a cluster. Distributed execution is less efficient than local execution. Therefore, OceanBase Database provides the table group syntax to bind business tables to a table group. This converts distributed execution into local execution and improves query efficiency.

On the TopSQL tab, click Column Management and select Proportion of Distributed Plans (%). Then sort the SQL statements on the tab by the Proportion of Distributed Plans (%) column.

1

Contact Us