on 2022 Oct 21 1:39 PM
Hello all.
I'm having a curious performance problem in Hana.
I have a TF with some complicated logic and then a graphical view with just one node pointing to the TF.
So if I make a count(*) to the TF it takes 1 sec, and the same query but over the grafical view takes 30 secs.
Anyone has any explanation for this?
I need the help of some experts like lbreddemann 🙂
Thanks
Dear Lars,
The version is 2.00.059.01.1642499117 (fa/hana2sp05)
Yes, both selects returns the same number of records. Like I said, the graphical view is just one node with the TF.
Sorry I'm not sure if I can publish that information... Also is quite big.
Any way of sending all that info as a private message?
I hope you don't mind.
And many many thanks for the help.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Sorry, a private message won't work.
This is a public forum; the whole point is to discuss topics in public.
For the visual information (planviz and graphical calc view) you may add screenshots.
For the EXPLAIN plan, usually one can re-format the textual table output to fit the forum page.
I have not been a regular in this forum for a couple of years now, as my professional focus has shifted.
Chances are that you can get a quicker/better answer by including the required information in the publicly visible question.
Yes Lars, you are totally right.
This is the info:
The Calc View and its plan:
The Main TF and the 3 TFs called (they are related to inventory):
User | Count |
---|---|
62 | |
12 | |
7 | |
7 | |
7 | |
6 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.