SQL Explain Query Review
Reference Contents > Client-Server SQL Database > SQL Explain Query Review
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.
Reference Contents > Client-Server SQL Database > SQL Explain Query Review
