When executing a SQL Statement in DWC, the generated remote query is not optimized, resulting in a longer execution.
In Remote query monitor you see that the HANA statement does not contain WHERE clause, JOINs or other SQL capabilities.
SAP Data Warehouse Cloud
fetch, execute, to_date, dynamic, filtering, functions, casting, cast, inner join, , KBA , DWC-DI-RT , Remote Tables , DWC-DI-CON , Connections , Problem
About this pageThis is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).
Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.