can indexing SQL tables improve the performance of a tableau dashboard?

I have a very high level question. could indexes on a sql server table improve the loading performance of a tableau dashboard?

if so – is there any best practice / guideline we could follow?

thanks a lot

Answer

Yes, it will speed up Tableau. Just like the indexes speed up any query (if applied properly), Tableau is the same way – it’s just querying the data and displaying the results.

Best practice ? Like everything else, analyse the usage to see where it is appropriate to apply indexes. Not enough is bad, too many is bad.