SAP HANA PROBLEM PERFORMANCE NVARCHAR
Hello,
We are using dg4odbc to connect to sap hana database.
Our problem is regarding performance.
My queries is only working well when I cast each parameter in where clause to include cast as nvarchar.
For example:
--This query is not running because the where clause is applied only after oracle bring full hana table to oracle side
select * from saphanadb.bsad@saphana_link
where bukrs = '0060'
and kunnr = '0000013580'
and augdt = '20200813'
--The same query but including cast as nvarchar2 works fine.
select * from saphanadb.bsad@saphana_link
where bukrs = CAST('0060' AS NVARCHAR2(100))