syntaxsql 复制 EXPLAIN [WITH_RECOMMENDATIONS] SQL_statement [;] 备注 Azure Synapse Analytics 中的无服务器 SQL 池不支持此语法。参数SQL_statementEXPLAIN 将在其上运行的 SQL 语句。 SQL_statement 可以是以下任何命令:SELECT、INSERT、UPDATE
In older MySQL releases, extended information was produced usingEXPLAIN EXTENDED. That syntax is still recognized for backward compatibility but extended output is now enabled by default, so theEXTENDEDkeyword is superfluous and deprecated. Its use results in a warning; expect it to be removed fromE...
In this case, the statement displays information only for the named column. wild, if given, is a pattern string. It can contain the SQL % and _ wildcard characters. In this case, the statement displays output only for the columns with names matching the string. There is no need to ...
EXPLAIN performance is sometimes influenced by the time it takes to create temporary tables. For example, a query that uses the common subexpression optimization requires temporary tables to be created and analyzed in order to return the EXPLAIN output. The query plan depends on the schema and sta...
If you want to query execution plans with higher readability, we recommend that you upgrade your Hologres instance to V1.3.4x or later. EXPLAIN Syntax You can execute the following EXPLAIN statement to query the execution plan that is estimated by the QO: EXPLAIN <sql>; Example In this ...
This topic provides a brief guide to the operational terms used in Athena EXPLAIN statement results. EXPLAIN statement output types EXPLAIN statement outputs can be one of two types: Logical plan –Shows the logical plan that the SQL engine uses to execute a statement. The syntax for this opt...
You can use this statement to obtain the execution plan of an SQL statement, which can be a SELECT, DELETE, INSERT, REPLACE or UPDATE statement. EXPLAIN, DESCRIBE, and DESC are synonyms. Syntax {EXPLAIN [INTO table_name ] [SET statement_id = string] | DESCRIBE | DESC} [explain_type] ...
Syntax of EXPLAIN ANALYZE in PostgreSQL EXPLAIN ANALYZE [query]; Where - query:The SQL query you want to analyze. When prefixed with EXPLAIN ANALYZE, PostgreSQL runs the query, collects statistics on how each part of the query was executed, and returns a detailed execution plan along with run...
V$SQL_PLAN - A dynamic performance view that shows the execution plan for a SQL statement that has been compiled into a cursor and stored in the cursor cache. Under certain conditions the plan shown when using EXPLAIN PLAN can be different from the plan shown using V$SQL_PLAN. For example...
1 EXPLAIN [ ( option [, ...] ) ] sql_statement; In the syntax above, sql_statement represents the SQL query you want to analyze, while the option parameter allows you to specify various options for the output of the explain plan command. Some common options include: ANALYZE: Provides ...