topic Re: Force oracle index /* in QlikView

Force oracle index /*

Tue, 13 Mar 2012 10:23:34 GMT

Dear all,

I'm trying to force index on script load, but I think that QV takes it as a comment an is not sending INDEX to the select.

Here you have an example

sql select /*+ index(table, index) */ * from table where field in (....)

I think that string /*+ index(table, index) */ is not loading on select because QV thinks that is a comment.

How can I add this string to select and do that QV sends on select.

Best regards.

Re: Force oracle index /*

Miguel_Angel_Baeyens — Tue, 13 Mar 2012 10:43:22 GMT

Hi,

There is indeed a system variable that is used to make QlikView "ignore" lines starting in // or /* as comments and process them. You can set this variable in the script and restore as soon as the load has finished:

Set StripComments = 0;
Table:
LOAD *;
SQL SELECT /* ... */
;
SET StripComments = 1;

Hope that helps.

Miguel

Re: Force oracle index /*

erichshiino — Tue, 21 Aug 2012 20:17:21 GMT

This post helped me a lot!

Thank you

Erich