Managing Connections in the SQL Terminal

In Data Studio, you can either use an existing connection or set up a new one in the SQL terminal to view the execution plan and cost, visualize the plan explanation, and work with the result set. By default, the SQL terminal reuses existing connections. When multiple queries are queued for execution in an existing connection, consider using a new connection to avoid delays caused by sequential execution. However, it is best to reuse existing connections when working with temporary tables. For how to edit temporary tables, see Editing Temporary Tables.

Perform the following steps to change the connection reuse setting:

  1. Click image1 to enable or disable the connection reuse function in the SQL terminal.

    For details about query execution behavior during connection reuse and creation, see FAQs.

    Note

    You can only edit temporary tables in existing connections.