BackgroundOne of my colleagues introduce a new Smart Data Access (SDA) ABAP adapter wTaking Data Federation to the Next Level: Accessing Remote ABAP CDS View Entities in SAP HANA Cloud”. The adapter is available from QRC 01/2024 onwards. The blog exp...
In early 2023, I had written "Faster query execution using lesser memory in SAP HANA Cloud" to show improvements in the SQL execution engine with faster execution using lesser memory. Since then, further enhancements have been done to improve the ove...
IntroductionTo resolve a problematic SQL statement inside a SQLScript procedure may require adding a hint to resolve the issue. For general SQL statements, a statement hint can be used to apply and manage hints without the changing the original sour...
I have written HEX blogs for both SAP HANA Cloud and SAP HANA Platform introducing the architectural benefits when queries are running with HEX.
Faster query execution using lesser memory in SAP HANA Cloud
Faster query execution with lesser memo...
Earlier this year, I have shared the information of improved query execution as Faster query execution with lesser memory for SAP HANA Cloud` introducing the latest development of HEX and the improvements achieved by HEX.
With SAP HANA Platform 2.0...
@Cocquerel The main difference is that RDB framework (Resilient Data Buffer) is based on Analytics annotation for Analytic CDS views. The target consumption is BW or DSP. While SQL Services based delta replication is for CDS view entity with limitati...
@Cocquerel Sorry, I'm not familiar with RDB framework (Resilient Data Buffer) to answer for your first question. Please check the documentation for DataIntegration.deltaReplication.intended
Hi @Cocquerel The annotation DataIntegration.deltaReplication.intended you've mentioned allows delta replication from CDS entities (replacement of DDIC) with SQL Service which is supported with replication flow in SAP Datasphere. The feature is not...
There is also applying the statement hint directly to a call procedure.ALTER SYSTEM ADD STATEMENT HINT (NO_USE_HEX_PLAN cascade) FOR call "GET_ORDERS#20220227123129"(?);