AWS Redshift – Analyzing & Vacuuming Tables

Analyzing & Vacuuming Tables

Vacuum –Deep Copy


• Is an alternate to VACUUM.

• Will remove deleted rows and also re-sort the table

• Is more efficient than VACUUM

• You can’t make concurrent updates to the table

• Deep copy options:

– Use original table DDL and run INSERT INTO…SELECT • Best option -Retains all table attributes

– Use CREATE TABLE AS

• New table does not inherit encoding, distkey, sortkey, primary keys, or foreign keys.

– Use CREATE TABLE LIKE

• New table inherits all attributes except primary and foreign keys – Use a TEMP table to COPY data out and back in again


0 views0 comments

Recent Posts

See All

What are the different AWS Support Plans Available?

AWS Support offers four support plans: Basic, Developer, Business, and Enterprise. The Basic plan is free of charge and offers support for account and billing questions and service limit increases. ..