topic Re: Sql hint in Connectivity & Data Prep

Sql hint

Omarov — Wed, 06 Aug 2025 08:14:55 GMT

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.

Re: Sql hint

marcus_sommer — Wed, 06 Aug 2025 13:11:30 GMT

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.

Re: Sql hint

rwunderlich — Wed, 06 Aug 2025 16:41:22 GMT

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/406743

-Rob

Re: Sql hint

Omarov — Fri, 08 Aug 2025 05:32:22 GMT

Thanks a lot Rob
--+ worked