Hello,
We are experiencing some performance issues in SAP due to SQL queries on certain tables, such JEST one, that are being executed from Qlik Sense enterprise (client-managed). I understand that it is possible to execute these same queries in an indexed manner, using statements like HINT, PARALLEL, or similar in order to improve the performance.
I am unable to find the correct syntax. It resulted in an error; or Qlik did not recognize the function because it thinks is a comment.
I tried several things without success. Below is the script I am using to attempt this with MARA table.
LIB CONNECT TO 'SAP';
SET StripComments=0;
SET vHint = '/*+parallel(4)*/';
[MARA]:
SELECT $(vHint)
*
FROM MARA
;
SET StripComments=1;
I would like to know if it is possible to do this, and if so, to know the correct syntax or if Qlik Sense requires any additional configuration.
Regards,
