Skip to Content

SQL Script in SAP HANA SQL Console.

Like in SQL Server, we have many features in SAP HANA as well. In SAP Console write a SQL statement and right click, you can see many options like below.

HANA1.png

It has segregated into some sections. common features are save, open, clear, etc..

HANA6.png

Important and useful features are, Execute, Explain Plan, Visualize Plan & Format.

I am explaining few of the features here.

Format:

Write a SQL Script as per your wish and click the format option, it will align as per standard.

/wp-content/uploads/2014/09/hana3_552867.png

Explain Plan

Without run, we can see the query plan. It will display many information including the row count in the output, etc..

HANA5.png

/wp-content/uploads/2014/09/hana4_552869.png

Preferences


/wp-content/uploads/2014/09/hana2_552870.png

To report this post you need to login first.

Be the first to leave a comment

You must be Logged on to comment or reply to a post.

Leave a Reply