Useful Info of HANA AMDP
Few things that i learned from my last project about AMDPs:-
- READ Only Procedures [ Options READ-ONLY ] execute faster as compared to Non-Read Only Procedures
- A Read Only Procedure can’t call a Non-Read Only Procedure but a Non-Read Only Procedure can make call to Read-Only Procedure.
- HANA DB Procedures not that good at IF…ENDIF. Try to avoid whenever possible.