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.