Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Partner
Partner

Oracle Parallel Hint Load

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.

1 Solution

Accepted Solutions
Highlighted
MVP
MVP

Hi

remove the space between / and +

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


I just tried on a table

with space the execution isn't parallel


noparallel.jpg


without space is parallel


parallel.jpg


View solution in original post

3 Replies
Highlighted
MVP
MVP

Hi

remove the space between / and +

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


I just tried on a table

with space the execution isn't parallel


noparallel.jpg


without space is parallel


parallel.jpg


View solution in original post

Highlighted
Partner
Partner

Bummer, thanks! Details Details...

Highlighted
Contributor
Contributor

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?