1. Home
  2. Knowledge Base
  3. Client-Server SQL Database
  4. 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.



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.

Was this article helpful?

Related Articles

Need Support?

Can't find the answer you're looking for?
Contact Support

Get started.

Try our state-of-the-art ERP Manufacturing Software today.