SQL review is a database management feature that checks and reviews SQL statements before they are executed to ensure the quality, security, and performance of the SQL statements.
Background information
SQL review currently supports the following features:
Identifying suspicious SQL statements based on specific principles.
Identifying newly added SQL statements based on the principle of no calls within 7 days.
The optimization center can review SQL statements executed within a specific period of time and provide optimization suggestions, including SQL optimization suggestions and structural optimization suggestions.
Procedure
Log in to the OceanBase Cloud console.
In the left-side navigation pane, click Instances.
In the instance list, find the target instance, click the instance name, and go to the instance overview page.
In the left-side navigation pane, click Diagnostics, and then select the Optimization Center tab on the Diagnostics page.
On the SQL Review tab, click Create Task in the upper-right corner.
In the dialog box that appears, configure the relevant parameters and click OK.
After the task is created, click View Details in the Actions column.
In the dialog box that appears, view the review suggestions.