Which is the better performing solution and how should I continue?
Hello everyone,
I want to do a report about the usage of construction machines.
As you can see on the Pictures (in the attachment!) I'm having solution 1 and solution 2.
Solution 1 is already finished with three tables (API Call E2, E7 and E8) which each one represents a whole REST-API call (dont mind the E7_items_u3_consumption table).
Solution 2 is only made for the REST-API call E7.
Later I should also join those tables with some SAP-Cost data by the serialnumer of the construction machines.
Now my question:
Which one is the better performing solution (especially if I join I it with the SAP-Data) and why?
My next question would be:
How should I continue? For example in solution 1, should I join those three tables (which join left, full join?) to one BIG table?
Kind regards and thank you in advance for your solutions