During system operation, to optimize SQL execution plans, you can actively bind execution plans or indexes to guide the SQL engine to follow a better execution plan. Additionally, to address emergencies, you can adopt temporary optimization measures such as binding execution plans, binding indexes, and throttling. This topic describes how to view active outlines and how to unbind execution plans and indexes and cancel throttling.
View active outlines
Log in to the OceanBase Cloud console.
In the left-side navigation pane, click Instances.
In the instance list, find the target instance and click the instance name to go to the Overview page.
In the left-side navigation pane, click Tenants.
In the tenant management list, click the name of the target tenant to go to the tenant overview page.
In the left-side navigation pane, click Diagnostics.
At the bottom of the Diagnostics page, click Optimization Center. The system displays the Active Outlines tab by default.
On the Active Outlines tab, view the currently active outlines.
Note
SQL statements bound by the Aggregation In Query feature are aggregated and displayed as one entry.
Unbind execution plans
On the Active Outlines tab, view the outlines that have bound execution plans.
Unbind the execution plans.
For individual operations: Find the target outline and click Unbind in the Actions column.
For batch operations: Find the outlines marked with Aggregated and click Unbind in the Actions column.
In the pop-up confirmation box, click OK.
Unbind indexes
On the Active Outlines tab, view the outlines that have bound indexes.
Unbind the indexes.
For individual operations: Find the target outline and click Unbind in the Actions column.
For batch operations: Find the outlines marked with Aggregated and click Unbind in the Actions column.
In the pop-up confirmation box, click OK.
Cancel throttling
On the Active Outlines tab, view the outlines that have been throttled.
Cancel throttling.
For individual operations: Find the target outline and click Cancel Throttling in the Actions column.
For batch operations: Find the outlines marked with Aggregated and click Cancel Throttling in the Actions column.
In the pop-up confirmation box, click OK.