Hi Cognoids, wondering if anyone has used Redshift with your Cognos queries? I am finding it slow and it seems like Redshift is using Sequential Scan on the tables and searches every row instead of filtering and only retrieving the needed ones. Anyone figured it out?
Thanks!