Help Center > > User Guide> Microsoft SQL Server Database Management> SQL Operations> Executing SQL Plan

Executing SQL Plan

Updated at: Mar 20, 2020 GMT+08:00

Scenarios

This section describes how to analyze the execution efficiency of the current SQL statement.

Prerequisites

You have obtained the login permission and logged in to the database management page.

Procedure

  1. On the menu bar, choose SQL Operation > SQL Window. On the displayed tab, select the required database from Database or click the target database node in the navigation tree on the left. Enter the SQL statements in the SQL window and click Execute SQL Plan.

    • On the Message tab, view the execution status of the SQL statements and the time required.
    • On the SQL Plan tab, view the execution status for each SQL statement.

Enter the SQL statement in either of the following format:

  • "SELECT * FROM name;": name indicates the table name.
  • "SELECT * FROM name1.name2;": name1 indicates the database name, and name2 indicates the table name.

Did you find this page helpful?

Submit successfully!

Thank you for your feedback. Your feedback helps make our documentation better.

Failed to submit the feedback. Please try again later.

Which of the following issues have you encountered?







Please complete at least one feedback item.

Content most length 200 character

Content is empty.

OK Cancel