Amazon Redshift | Maintenance

Question 1

I notice that some queries accessing data in my cluster are running slower than my Redshift Spectrum queries. Why is that?

Maintenance

Amazon Redshift | Database

Answer 1

Amazon Redshift queries are run on your cluster resources against local disk. Redshift Spectrum queries run using per-query scale-out resources against data in S3. For most queries, local disk will be faster, but for queries that scan a lot of data and do minimal compute processing, we can apply a lot of Redshift Spectrum workers and complete them quickly.