In some circumstances, selecting Assume Referential Integrity from the Data menu might help increase query speed. Tableau will only include the connected table in the query if it is directly referenced by fields in the view when you select this option.