Time taking for inner joins in select

[Former Member]

Hi all,

I am using inner join on 3 tables ( PLKO,PLPO,PLAS) for the materials,

it is taking database time 20% and abap time 78 % and when i am using FM CARO_ROUTING_READ

database time 48% and abap 52%.

i am in confusion which is th ebest method to use inner join or FM.

when i am checking in the server for plant in the selection screen , it is running lot of time

This is first time i am working on the performance issue.

Can you please anbody help me how to solve this issue.

Regards,

Madhavi

[Sandeep_Kumar]

I will go for FM.

Also , the runtime analyser can give diff results for the same based on system load.

[ThomasZloch]

Percentages don't mean much, how does the overall runtime compare? Is there a problem at all?

Since you already used SE30, go a step further and study the hit list sorted by net time descending, only look at the top few items.

Also read this:

Thomas

[Former Member]

closed