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.