Sql hint

[Omarov]

Hi
I have a SQL script that runs in 15 minutes in PL/SQL Developer, but in Qlik Sense, it takes almost 1 hour to execute.

in PL/SQL Developer:
WITH A AS (
SELECT /*+ PARALLEL(16) */
DISTINCT TR.TRN_DT, 

in the Qlik Sense load editor:

tablle1:
NoConcatenate
LOAD *,
date(floor(TRN_DT)) as trn_date;

SQL WITH A AS (
SELECT /*+ PARALLEL(16) */
DISTINCT TR.TRN_DT,

I think it is because of the hint.
Can anyone help me.

[marcus_sommer]

Qlik doesn't execute any sql else transfers the statement and received the result data-set. Therefore the cause is the network, the driver, any queuing/locking or similar stuff.

[rwunderlich · Accepted solution]

By default your "/*+ hint */" is stripped from the SQL before being sent to the DB server. You will need to 

set StripComments=0;

Alternatively use the -- SQL comment syntax.

See https://community.qlik.com/t5/QlikView-App-Dev/Oracle-SQL-Select-Statement-with-quot-Hint-quot/td-p/...

-Rob

[Omarov]

Thanks a lot Rob
--+  worked