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

How to Install & Configure AWSCLI on macOS ?

Users using macOS can follow the below command and steps to install the latest version of AWS CLI.The user should have sudo access to execute the below command. ​​For the latest version of the AWS CLI