Help Center> Data Admin Service> User Guide> MySQL DB Instance Management (Standard Edition)> SQL Operations> SQL Window
View PDF

SQL Window

Procedure

  1. On the top menu bar, choose SQL Operations > SQL Window.
  2. In the navigation pane, specify a database, table, or view.

    Figure 1 SQL Window
    • Execute SQL: executes SQL statements.
    • Tune SQL: queries the SQL statements that are executed frequently, consume a large amount of resources, or take a long time to execute.
    • Execute SQL Plan: reports the execution of SQL statements to facilitate troubleshooting and optimize SQL processing performance.
    • SQL Favorites: allows you to add, view, and manage frequently used SQL statements.
    • Format SQL: improves the readability of SQL statements. Formatting SQL statements enables statements to be displayed in line break mode, but does not change their logic and semantics.
      Figure 2 SQL statements before formatting
      Figure 3 SQL statements after formatting

  3. After SQL statements are executed, view SQL execution status on the Executed SQL Statements, Messages, and Result Set tab pages.
Parent topic: SQL Operations