topic Oracle Parallel Hint Load in QlikView

Oracle Parallel Hint Load

avastani — Thu, 09 Jan 2014 15:10:01 GMT

I am using SQL SELECT /* + parallel */ * FROM user.bigtable along with the SET StripComments = 0; before the select, however, the performance on my extract is still no different than without in v11.2SR5.

The table has 20M rows and 300 columns

Has anyone else faced the same problem? Any resolutions to it? thanks in advance for your replies.

Re: Oracle Parallel Hint Load

maxgro — Thu, 09 Jan 2014 16:15:30 GMT

remove the space between / and +

SELECT /*+ .........

I just tried on a table

with space the execution isn't parallel

without space is parallel

Re: Oracle Parallel Hint Load

avastani — Thu, 09 Jan 2014 18:55:01 GMT

Bummer, thanks! Details Details...

Re: Oracle Parallel Hint Load

Veppvepp — Tue, 24 Mar 2020 14:25:38 GMT

All,

I am using Oracle Odbc Connector Package 5.12.0 and tried using suggested options like below but still not able to enable Parallel in the Oracle. Could you please let me know what else I should do?

1) --+ PARALLEL

2) /*+PARALLEL*/

3) /*+PARALLEL(5)*/

Note : While using OLEDB connection, everything works but we don't want it in OLEDB due to project reasons.

Why is it not working or Oracle Connector?