View DDL statements DML&DQL SELECT INSERT INSERT ON CONFLICT(UPSERT) INSERT OVERWRITE COPY DELETE UPDATE TRUNCATE ANALYZE and auto-analyze Accelerate the execution of SQL statements by using fixed plans Query data across databases (beta) SQL transaction capabilities HINT EXPLAIN and EXPLAIN ANALYZE Prox...
The EXPLAIN command will fail if you use it for other SQL commands, such as data definition language (DDL) or database operations. The EXPLAIN output relative unit costs are used by Amazon Redshift to choose a query plan. Amazon Redshift compares the sizes of various resource estimates to ...
dml_statement The DML statement. Examples Explain an SQL query and store the obtained execution plan in the test table. /* Create a table named test. */ obclient> CREATE TABLE test (statement_id VARCHAR(30), plan_id INT, gmt_create TIMESTAMP, remarks VARCHAR(4000), operator VARCHAR(255...
TheEXPLAINPLANstatement is a data manipulation language (DML) statement, rather than a data definition language (DDL) statement. Therefore, Oracle Database does not implicitly commit the changes made by anEXPLAINPLANstatement. If you want to keep the rows generated by anEXPLAINPLANstatement in the...