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...
Happy New Year!
thomas.hammer3 last week wrote a blog introducing new features available with Q4 2022 release of SAP HANA Cloud. I would like to also mention some enhancements done for SQL query execution for 2022 overall.
If you have been using th...
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"(?);
Hi Gana,
XSC runs within HANA system and is inactive in HANA 2.0 and needs manual activation. So, there is no dependency as part of Hyperscalers. Keep in mind that HANA 1.0 is end of support and XSC running in HANA 2.0 may not be supported in fut...
Can you share the version of SAP HANA Cloud being used? We have provided a fix for QRC04-2022 for it but please let us know if the issue still remains.