We have created a DB link between Oracle 12c and HANA database. We are trying to request a subset of data using a simple SQL statement from Oracle to HANA -
Select comp_code fiscyear amount_loc_currency from "SAP"."/BIC/AZOGL00"
where fiscyear = '2016'.
If we see the plan cache in HANA, we notice that Oracle does not pass the 'where' clause to HANA. instead it's requesting all the data from the ZOGL DSO and then will restrict/filter the data in Oracle. So instead of getting 200 records from HANA, it get 300 million records and then displays the result set of 200. Due to this large data transfer, a 2-5 second query takes almost an hour.
We tried using hints, specifically DRIVING_SITE, but it did not change the statement that was passed to HANA.
Has anyone faced a similar issue? Any suggestions will be appreciated.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.