My report is executing a query which roughly will take 10sec to get the result back from Greenplum. My issue is, seems like Tableau Server is executing several validation queries (which ends with 'LIMIT 1'). There are 3 of the validation queries from the attached log, which took 10sec each and only the last query is needed to populate the report.
If there is a way to disable Tableau Server from running the validation queries, then it will be a great win for performance improvement. Does anyone know whether this is possible?