Showing results for 
Search instead for 
Did you mean: 

DBACOCKPIT and HANA Studio SQL console difference?



Might be a daft question but this one some times confuses me.

Lets assume that I fire a select query on a single table which brings 10,000 records. Is there any difference in terms of performance if I fire this query in DBACOCKPIT or if I fire this query using the HANA Studio SQL console?

Is my understanding correct that DBACOCKPIT will be slower compared to HANA stuid SQL console as it has to bring the data back into application layer to display the results in SAP GUI?



Accepted Solutions (1)

Accepted Solutions (1)

Active Contributor

Both your ABAP worker processes and the SAP HANA Studio are application level processes. HANA Studio is not “closer” to the database than your ABAP transaction in any meaningful way.

Bringing back records may be faster or slower or the same with either option, but this difference is not due to where they are located in the application layer hierarchy.

Answers (1)

Answers (1)

0 Kudos

Hi Satya,

Q 44 of SAP Note 2000003 - FAQ: SAP HANA may help demystify some of the mistery at least.

Best Regards,
Kashyap Shah