Which is the better performing solution and how should I continue?

[Thomas_5]

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

Thomas

Solution 1:

Solution 1

Solution 2:

Solution 2