Avoid inner Join Between likpuk and lipsup

[Former Member]

Hi ,

i am using an inner join Between likpuk and lipsup, but its taking lot of time to execute,

the inner join is between two views, is there any other way to get the same what i am getting from the below inner join..

SELECT a_{vbeln b}matnr b_{werks b}lgort b~charg FROM likpuk AS a INNER JOIN lipsup AS b

ON a_{vbeln = b}vbeln INTO TABLE tb_delivery

WHERE a_{kostk = 'C' AND b}wbsta NE 'C' .

thanks in advance,

vinayaka

Move to correct forum

Edited by: Rob Burbank on Feb 18, 2009 1:55 PM

[Former Member]

Hi ,

i am using an inner join Between likpuk and lipsup, but its taking lot of time to execute,

the inner join is between two views, is there any other way to get the same what i am getting from the below inner join..

SELECT a_{vbeln b}matnr b_{werks b}lgort b~charg FROM likpuk AS a INNER JOIN lipsup AS b

ON a_{vbeln = b}vbeln INTO TABLE tb_delivery

WHERE a_{kostk = 'C' AND b}wbsta NE 'C' .

thanks in advance,

vinayaka

Move to correct forum

Edited by: Rob Burbank on Feb 18, 2009 1:55 PM

[Former Member]

You can get rid of the JOINs and views, but the problem is that you are not using any index.

Rob

[Former Member]

Hi Rob,

thanks, But when we are using Views we wont be having keys and all.............

do you have any idea on tables which contians the data from the select query with

keys which improves the performance, since the select statement what i am using now its alone taking more than 10secs which fetches records with more than 10,000 records....

or is there any way to improve performance of the select query what i am using ?

thanks,

vinayaka

[Former Member]

Views use the keys of the tables they are based on. You can run this in the background if necessary.

Rob

[Former Member]

Hi,

I recommend to do join between LIKP and LIPS transparent tables using the indexes (as far as possible) and to verify estatus of delivery in the VBUK table.

hope this information is help to you.

Regards,

José