1 of 1 people found this helpful
Most of the time, poor performing joins has more to do with the database than Tableau. I'd suggest that you look at optimizing your queries at the database level. There are lots of things that can be done here, but I'd start by looking at indexes. I've seen indexes take a query that took 1 hour to run and reduce it to seconds. If you can temporarily convert your Tableau joins to custom SQL, you should then be able to use database tools to analyze the query execution plan. This should allow you to see areas that can be improved. Some tools, such as those available for SQL Server, will even give you recommendations for indexes.
Thanks Ken, this is helpful - I'm wearing several hats at my org, including Tableau server admin and DBA, so I have some learning to do on the RDBMS side of things.
you should then be able to use database tools to analyze the query execution plan.
Are you speaking in generic terms about database tools, or one specific to Tableau that analyzes queries?
I'm speaking about DBMS-specific tools, such as SQL Server Management Studio or Oracle SQL Developer.
What RDBMS are you using? I'm a former SQL Server DBA, so I can probably provide some specific guidance for SQL Server.
We have everything in MySQL on AWS
Well, I can't help a lot there, unfortunately. Good luck. If you have any higher level or conceptual questions, I'm happy to help out.