Menu
Amazon Redshift
Database Developer Guide (API Version 2012-12-01)

Automatic Analysis of New Tables

Amazon Redshift automatically analyzes tables that you create with the following commands:

  • CREATE TABLE AS (CTAS)

  • CREATE TEMP TABLE AS

  • SELECT INTO

You do not need to run the ANALYZE command on these tables when they are first created. If you modify them, you should analyze them in the same way as other tables.