Run a read-only SQL query and read its plan
The "SQL Editor" tab runs SQL in Read-only mode by default. "Explain" shows the query plan without running the statement.
Have questions or need step-by-step guidance on this topic?
Step-by-Step Procedure
Open the editor
In the Database Explorer click "SQL Editor" (or press Alt+3). The box starts with SELECT now() AS server_time;. Clicking a table in the left list inserts its name at the cursor.
Check the mode
The "Mode" switch should read "Read-only" (green).
Run
Click "Run" (Ctrl/Cmd+Enter) to run the selection or the whole script, or "Run statement" (Ctrl/Cmd+Shift+Enter) for the statement at the cursor.
Read the results
A header shows the statement count, time and audit ID; a tab per statement lets you switch; "Export CSV" saves the grid. Results beyond the limit show "truncated".
Explain
Click "Explain" (Ctrl/Cmd+E) to see "Query plan (not executed)". "Format" tidies the SQL.
The query results or plan appear below the editor. Every statement is written to the audit ledger before it runs.
Was this guide helpful?
Help us refine our platform documentation