SQL 型 V3.2.4 开发指南 SQL 语法 普通租户(MySQL 模式) SQL语句 EXPLAIN 更新时间:2025-05-02 23:00:01 描述 该语句用于解释 SQL 语句的执行计划,可以是SELECT、DELETE、INSERT、REPLACE或UPDATE语句。 EXPLAIN与DESCRIBE、DESC互为同义词。 语法 {EXPLAIN|DESCRIBE|
OceanBase 数据库 SQL 型 V4.0.0-preview 参考指南 应用开发参考 SQL 语法 普通租户(MySQL 模式) SQL 语句 EXPLAIN 更新时间:2024-08-01 16:27:40 描述 该语句用于解释 SQL 语句的执行计划,可以是SELECT、DELETE、INSERT、REPLACE或UPDATE语句。 EXPLAIN与DESCRIBE、DESC互为同义词。
* In text format, es->indent is controlled in this function since we only * want it to change at plan-node boundaries. In non-text formats, es->indent * corresponds to the nesting depth of logical output groups, and therefore * is controlled by ExplainOpenGroup/ExplainCloseGroup. */stati...
The output of the EXPLAIN ANALYZE statement provides the actual execution path of an SQL statement. The output is displayed in a tree structure and contains detailed execution information of each operator at each phase. The output of the EXPLAIN ANALYZE statement contains the following parts: query...
The last two pieces of information can be used as arguments to add hints to the statement. The low-level options allow the inclusion or exclusion of fine details, such as predicates and cost. The example in Figure 5 displays the basic execution plan and includes information on any predicates...
LogicalOp- Relational algebraic operator for this step EstimateIO- Estimated IO cost of this step EstimateCPU- Estimated CPU cost of this step EstimateRows- Estimated number of rows produced by this step AvgRowSize- Average size of the rows in bytes processed by this step ...
LogicalOp- Relational algebraic operator for this step EstimateIO- Estimated IO cost of this step EstimateCPU- Estimated CPU cost of this step EstimateRows- Estimated number of rows produced by this step AvgRowSize- Average size of the rows in bytes processed by this step ...
EXPLAIN PLAN FORSQL_Statement For example: EXPLAIN PLAN FORSELECT last_name FROM employees; This explains the plan into thePLAN_TABLEtable. You can then select the execution plan fromPLAN_TABLE. This is useful if you do not have any other plans inPLAN_TABLE, or if you only want to look...
The SQL uses some operators to throw queries like SELECT uses to selects a data value and shown on the output screen, Where uses for conditions, Group by uses to group the output, Joins uses to join the two or more tables with the ...
12.1.3.1 Using V$SQL_PLAN Views In addition to running the EXPLAIN PLAN command and displaying the plan, you can use the V$SQL_PLAN views to display the execution plan of a SQL statement: After the statement has executed, you can display the plan by querying the V$SQL_PLAN view. V$SQL...