Explaining SQL Processing Results

[Former Member]

Peeps,

I ran a query in the hana sql window and it had these processing results:

successfully executed in 101 ms 821 µs  (server processing time: 67 ms 263 µs)

Fetched 1000 row(s) in 250 ms 602 µs (server processing time: 0 ms 982 µs)

I ran another query  and it had these processing results:

successfully executed in 117 ms 168 µs  (server processing time: 80 ms 906 µs)

Fetched 1000 row(s) in 184 ms 352 µs (server processing time: 0 ms 722 µs)

Can it be assumed that the one with the FASTER EXECUTION TIME -> 101 ms is the fastest or is it the one that FETCHED 1000 ROWS FASTER -> 184 ms?

Also, when viewing the Vis Explan Plan, I'm assumming the one with the lowest ESTIMATED COST runs the fastest - TRUE?

Mike

[former_member182302]

You will have to consider the server processing time of "executed" statement for performance.

Fetched rows shows the time taken to display the results for you.

Regards,

Krishna Tangudu