The SQL optimization feature provides you with one-click SQL statement optimization and the corresponding execution plan modification and optimization suggestions. SQL optimization is suitable for scenarios such as slow SQL statement business optimization, pre-release code review, and self-check. The optimizer uses a command line-style text input page to provide you with visualization platform component services and recover your database usage habits as much as possible.
You can manually enter SQL statements and analyze them to get their performance evaluation results and optimization suggestions.
Currently, SQL optimization is supported only for TencentDB for MySQL (excluding the Basic Edition).
- Make sure that the entered SQL statement is syntactically correct and the corresponding table exists in the target database.
- The analysis does not actually execute the SQL statement and has no affect on the actual data in the database.
- Currently, optimization plans are provided only for SELECT statements.
Professional optimization suggestions are provided for the entered SQL statement, including but not limited to index suggestions and SQL rewrite suggestions. You can optimize the SQL statement with performance problems using the optimization suggestions provided by DBbrain.