Force oracle index /*

[#1]

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.

[Miguel_Angel_Baeyens · Accepted solution]

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

[erichshiino]

This post helped me a lot!

Thank you

Erich