Data-On-Demand with TeraData Database

Hi all,

We are experimeting an issue with a Data-On-Demand data table based on a single TeraData table . This Data-On-Demand data table is filtered using 2 fields from another data table.

We have noticed that the request issued to the TeraData database is not efficient and causes some issues.

For instance, let's say that the columns  used to filter out the data are NUM_CIE_OPR an NUM_PAY_VEN and we have the following set of filtered data :

filters

The TeraData connector generates a very strange request especially on the WHERE clause. It goes like :

WHERE (((((("F_FAGSWD#VSWD_FWB_PAX_DET"."NUM_CIE_OPR" IN (55) AND "F_FAGSWD#VSWD_FWB_PAX_DET"."NUM_PAY_VEN" IN (15)) 
OR ("F_FAGSWD#VSWD_FWB_PAX_DET"."NUM_CIE_OPR" IN (55) AND "F_FAGSWD#VSWD_FWB_PAX_DET"."NUM_PAY_VEN" IN (20))) 
OR ("F_FAGSWD#VSWD_FWB_PAX_DET"."NUM_CIE_OPR" IN (55) AND "F_FAGSWD#VSWD_FWB_PAX_DET"."NUM_PAY_VEN" IN (25))) 
OR ("F_FAGSWD#VSWD_FWB_PAX_DET"."NUM_CIE_OPR" IN (57) AND "F_FAGSWD#VSWD_FWB_PAX_DET"."NUM_PAY_VEN" IN (15))) 
OR ("F_FAGSWD#VSWD_FWB_PAX_DET"."NUM_CIE_OPR" IN (57) AND "F_FAGSWD#VSWD_FWB_PAX_DET"."NUM_PAY_VEN" IN (20))) 
OR ("F_FAGSWD#VSWD_FWB_PAX_DET"."NUM_CIE_OPR" IN (57) AND "F_FAGSWD#VSWD_FWB_PAX_DET"."NUM_PAY_VEN" IN (25)))

Which is not efficient because as we have more filters, we have a very long request that sometimes happens not to be accepted by TeraData.

Is there any way to force the connector to generate a more efficient request. Something like :

WHERE (((((("F_FAGSWD#VSWD_FWB_PAX_DET"."NUM_CIE_OPR" IN (55,57) AND "F_FAGSWD#VSWD_FWB_PAX_DET"."NUM_PAY_VEN" IN (15,20,25)

would be nice.

Regards,

(1) Answer

Login