The PlanVisualizer is THE performance tool for the executions inside the HANA database. It can be used for simple SELECT statements and for the more complex statements which come in with the code push down into the HANA database. It is a tracing tool...
the locked thread below is actually as different as any other unlocked thread
UP TO 1 ROWS
where
doc_number = wa_pdate_temp-salesdoc and
s_ord_item = wa_pdate_temp-salesitem and
sched_line = wa_pdate_temp-sline
order by /bic/zpviewdt descending .
The...
I see very often the recommendations for parallel index processing on internal tables,but I am not convinced by these solutions and I sometimes write that behind these recommendations (It is about the solution not the person).The solutions assume usu...
when I answer three times in a thread then I expect an answer by the original poster anda moderator who closes the thread !If no answer comes the thread will anyway disappear.Siegfried
If you ask questions you should also distribute points when you get a good answer!I don't really need points, BUT+ I want to feed the world (see U.N. World Food Programme)+ and I would like to see whether a solution was found and which answer was...
Hallo,please add a loop around the 2 measurements and run it 10 or 20 times.Show what you did measure. Do not normalize and show just integer numbers for you measured,(t2 - t1) and (t1 - t0)The sort should not be inside the measurement!, it is done...
>Yes, we are talking the microseconds here but sometimesYou are right, microseconds .... in total, it is done only once at initialization and not once per row.
Hallo Thomas,you are right is probably the minimum, I use very often the minimum to get with less statistics good results. Especially in the case of internal tables (not published report)you need the minimum to get the logarithm of the binary search ...
Hallo,As written above there is a framework program which you can use for runtime tests. Traces have an overhead and not ideal for runtime measurements.Get the program here:dpunkt.verlag :: Performance-Optimierung von ABAP®-Programmen - Wie Sie Ihre ...
This is the Hana Live design criteria right from the beginning:However, back to the original question: Hana Live views are build exclusivley in graphical calculation views, even scripted views are exceptions, analytical and attribute views are not al...
