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

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