SQL Performance (MOSC)

MOSC Banner

SAP HANA PROBLEM PERFORMANCE NVARCHAR

edited Dec 11, 2020 10:29AM in SQL Performance (MOSC) 4 commentsAnswered

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))

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center