HANA - Accelerate SQ01 Queries

[Former Member]

Hello,

We recently went live with HANA Side Car Configuration and have configured standard Financial accelerators available in HDBC.

We have also accelerated some custom Z reports and have got great performance improvement.

Next we would like to tackle a no. of SQ01 queries.

I created the accelerator for one of the query and loaded using RDA_MAINTAIN. We did no see any significant performance improvement.

Is it possible to accelerate SQ01 queries ? Has anyone accelerated SQ01 queries ? 

Regards,

Manoj

[former_member196555 · Accepted solution]

Hi Manoj,

You will have to do some analysis to identify if the query can be accelerated.

I would suggest you to trace the report using ST12 and then have a look at the query in

SQL cursor cache.

You can access SQL cursor cache from DB02/DBACOCKPIT transaction. You will see the total response time of the query divided into I/O time, CPU time and others.

In general, you will see benefits with HANA only when I/O time is maximum.

You can even think of re-writing the query. e.g. In few cases writing JOIN will help in improving performance rather than relying on FOR ALL ENTRIES.

Regards,

Harshad.