1. Home
  2. Client-Server SQL Database
  3. Client-Server SQL Database: SQL Explain Query Review

Client-Server SQL Database: SQL Explain Query Review

SQL Explain Query Review

SQL Explain Query Review window

The EXPLAIN SQL prefix instructs the server to tell the client how it would navigate the database to perform the statement that follows the keyword. It allows you to see the optimiser’s plan of execution. This can be useful to professionals trying to speed up complex statements. Caliach Vision implements this with Dynamic Queries using the Shift key. If pressed when triggering a report, instead of the report being produced, a window will open to show the optimiser plan.

Each server engine presents different information. See the server engine web sites for an interpretation.

Field

Description

SQL Statement

The SQL query text that produced the results.

Explain query results

Results returned from the server.

See also: –

Compiled in Program Version 5.10. Help data last modified 7 Jan 2015 09:12:00.00. Class wSqlExplainQueryResult last modified 10 Oct 2017 11:48:51.

Updated on May 27, 2020

Was this article helpful?

Related Articles

Leave a Comment