Hello,
I have huge oracle database with few indexed fields. I create direct connection in Tableau desktop and add filter on indexed fields to worksheet.
If i add less then 10 different values to custom value list it generates sql where part like this:
WHERE ("BL_TRAFFIC"."USER_ID" IN ('A', 'B', 'C', ....))
This type of SQL works really fast as it uses indexes.
The problem:
If I add more then 10 different values Tableau generates SQL like this:
<QUERY protocol='05136d88'>
SELECT *
FROM (SELECT "BL_TRAFFIC"."USER_ID" AS "USER_ID"
FROM "TEST"."BL_TRAFFIC" "BL_TRAFFIC"
GROUP BY "BL_TRAFFIC"."USER_ID"
ORDER BY 1 ASC NULLS FIRST)
WHERE ROWNUM <= 56
</QUERY>
As database ir really huge SQL above extracting data for too long. Is there any wayt to change a way how Tableau generates SQL or force him to use Where ( IN())?
V.
This is still true in Tableau 2018.1, and we're bumping up against it as it leads to very slow performance on the view.
Become a Viz Whiz on the Forums! Support the Community and master Tableau.