cancel
Showing results for 
Search instead for 
Did you mean: 

DBACOCKPIT and HANA Studio SQL console difference?

former_member654791
Discoverer

Hi,

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?

Thanks

Satya

Accepted Solutions (1)

Accepted Solutions (1)

lbreddemann
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)

kashyap_shah3
Contributor
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