Amazon Web Services (AWS) Redshift queries are slow

Never forget the golden rule of AWS Redshift.

“Whenever you add, delete, or modify a significant number of rows, you should run a VACUUM command and then an ANALYZE command.”

This will speed up your queries.

Vacuum command will clear any deleted space and tune the database.