HANA AMDP- Useful Info

light111Useful 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.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s