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 ...
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...