Skip to Content
0
May 11, 2015 at 02:24 PM

Best Practice for TCUR tables and Currency Conversion

362 Views

Hi,

I am currently struggling with the built-in SAP HANA Currency Conversion. If I enable a single column for currency conversion and use it in my query instead of the original column/measure the run-time of the query slows down by about 4 times. So instead of 3 second the query now runs ~12 seconds with the measure that uses currency conversion.

I already limited the TCURR and TCURF to only include relevant exchange rates (7.5M rows vs. 2.5M rows) which already saved me ~5 seconds per query

I also tried to changed the tables from column-tables to row-tables but this was just a test and made the performance even worse (>30 seconds)

So my question is how I could tune that?

Can anyone provide to original SQL create scripts for the TCUR tables from SAP?

Would it help to create any indexes?

What other options do I have to tune currency conversino?


thanks in advance!


-gerhard