Does RedShift offer better performance?

cwolman

I am currently using MySQL data flows and indexing the join fields appropriately but performance seems underwhelming when dealing with millions of rows and/or GB sized data sets.  Would I see a performance benefit utilizing RedShift?  I began looking into the RedShift documentation and the first difference of note was indexes vs sort key.  How do you handle this difference in Domo? 

 

Thank you in advance for your responses.

AS

We also use Redshift exclusively.  Our datasets range from dozens of rows to dozens of millions of rows.

 

Some benefits for my perspective: 

1) No indexing, less maintenance

2) Faster processing on larger datasets

3) Common table expressions, window functions, etc (mysql didn't have this previously, though I've heard that may have changed)

 

I used to be all about MySQL when I worked for Domo, but that indexing step really bugged me.  I don't want that hassle so for me it's a big win to be free of query optimization like that.