Guidelines for HANA SQL Script

[raghavendragonuguntla]

Dear Experts,

Could you please share best practices on the usage of SQL script in procedures and Script based calculation views?

I searched already for the relevant information, but could not find any yet. I request you share any information other than what is available in help.sap.com based on your experience.

Thank you,

Raghavendra.

[Former Member · Accepted solution]

Hi Raghavendra,

As Lars said, it is very difficult to answer your question and it always depend on the designing solution for specific requirements. General rules we follow in scripting are

1. Avoid inline queries

2. Break complex SQL to small and simple SQL statements and club the results

3. Always analyze cost using Visualize Plan

4. Avoid cursors/loops

5. Avoid mix of SQL and CE (most commonly found best practice )

Regards,

Chandra.

[raghavendragonuguntla · Accepted solution]

Thank you Chandra.