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.

[lbreddemann]

"Show me best practices" is a too broad question.

What exactly are you looking for?

The developer guides available on help.sap.com and in your SAP HANA Studio provide you with "what to use when" on a general level.

More specific guidance can be found here on SCN - given you search specifically for them.

- Lars