Question Re: Guidelines for HANA SQL Script in Technology Q&A

Guidelines for HANA SQL Script

raghavendragonuguntla — Mon, 13 Apr 2015 13:02:23 GMT

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.

Re: Guidelines for HANA SQL Script

lbreddemann — Mon, 13 Apr 2015 13:39:36 GMT

"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

Re: Guidelines for HANA SQL Script

Former Member — Tue, 14 Apr 2015 10:03:13 GMT

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.

Re: Guidelines for HANA SQL Script

raghavendragonuguntla — Wed, 29 Apr 2015 04:23:08 GMT

Thank you Chandra.