-
1. Re: Parameter in custom SQL query taking forever in Computing view layout.
Patrick A Van Der HydeJul 9, 2018 10:33 AM (in response to Gagan Thapar)
Hello Gagan,
I am guessing this is caused by the select * that wraps around the custom sql. See Connecting Through Custom SQL Causes Slow Performance | Tableau Software
Patrick
-
2. Re: Parameter in custom SQL query taking forever in Computing view layout.
Gagan Thapar Jul 10, 2018 11:36 AM (in response to Patrick A Van Der Hyde)Thank you. I don't know then why is it working fine when I have the hard coded parameter value in the query.
I noticed one more thing. I input the parameter so that query just has to run 100 records. It was still not working. Then I added "And rownum < 500) and the query worked. I don't know what's going on here. The cost of both the queries was exactly same.
SELECT COLUMN_A,
FROM TABLE_A ss, TABLE_B sc, TABLE_C pse, TABLE_D ps
WHERE ss.hnspartnerid = sc.swcustomerid
and sc.COMPANY = <Parameters.CustomerID>
and ss.SITE = pse.SRCSITE
and pse.SITE = ps.SITE
AND ss.ACTTYPE <> 'Physical Location'