This functionality of qlikview used to increase the performance of your script code via using the functionality of Oracle to "interpret the comment as a list of hints" .
Syntax:-
in order to use this please set Set StripComments=0; befor your code.
now include your code as :
Set StripComments=0
Tablex:
select /* + Index(tablename, Colmn name)*/
* from
Table_name;
Set StripComments=1;
please make sure, The plus sign must immediately follow the comment delimiter and no space is permitted. Also set Strip comment to 1 after the query otherwise stripping of comments will always be performed.
Syntax:-
in order to use this please set Set StripComments=0; befor your code.
now include your code as :
Set StripComments=0
Tablex:
select /* + Index(tablename, Colmn name)*/
* from
Table_name;
Set StripComments=1;
please make sure, The plus sign must immediately follow the comment delimiter and no space is permitted. Also set Strip comment to 1 after the query otherwise stripping of comments will always be performed.
You contact B2IT as they are Qlik specialist. May might also find these articles useful: https://b2it.co.za/blog/removing-qlikview-backend-script-variables-frontend
ReplyDeletehttps://b2it.co.za/blog/cleaning-temp-tables-and-fields-qlikview-and-qlik-sense
Thanks for providing the syntax and use of strip comment. I've been looking around for it but couldn't really find the appropriate answer. Your post was much comprehensive and helpful. Thanks and keep posting.
ReplyDeleteQlik Soap Api Connection