1 of 1 people found this helpful
Hey Russel. Tableau will only query those fields that it needs to query in order to create the visualization you wanted, so you shouldn't need to manually eliminate any. The list of fields in the Data pane are essentially showing you "here are all the fields available to you"--but just having them there doesn't mean Tableau is querying them each time.
The exceptions to this are when you are extracting the data, in which case I'd recommend the "hide unused fields" button, or when you are using Custom SQL in your connection--then it would make sense to avoid a SELECT * and trim down to just the fields you need.
There are lots of ways to try and improve performance, however. I highly recommend Alan Eldridge's whitepaper on this--lots of great tips!
Thanks for the quick response and the link to Alan's whitepaper!
Do you know where I can expose the query that Tableau is sending to the server?
There's a query window in the Performance Recording but it is blank.
In the performance recording, if you view all underlying data for an Execute Query mark, you should see the query. You can also find begin-query and end-query entries in the Tableau Desktop logs, typically located in the "My Tableau Repository" folder.
I also found this TC16 video TODAY :-) by Anika Martynowych on Calculations and Performance. In the first 5 mins she's talking about the Performance Recorder and clicking on the Query Bar to fill the Query Window.
Thanks for the log tip.
You Can you data source filter