Skip to Content
Nov 24, 2014 at 03:11 PM

SAP Hana view from SQL Server


Dear experts,

We have a performance problem with a view on Hana consumed from SQL Server. If we do an select without parameters, the view returns 450.000 registers and take more than 50 seconds on SQL Server. If we aggregated some parameters on SQL Server the view returns 3 registers and takes more than 20 seconds. I doing a trace on Hana and the view always returns the 450.000 registers and then the SQL server do the filter. There is any way that Hana can do the filter and return to SQL Server only the correct registers???

Best regards