topic Re: Making select statement efficient in Application Development and Automation Discussions

Making select statement efficient

Former Member — Fri, 01 Sep 2006 02:35:11 GMT

Can any one suggest how to make this below statement efficient? It is taking quite a long time to run, wht could be the reasons.

SELECT pbim_{bedae pbim}versb pbim_{pbdnr pbim}matnr pbim~werks

pbed_{pdatu pbed}plnmg pbed~meins

pbed~aenam

FROM pbim

INNER JOIN pbed ON pbed_{bdzei = pbim}bdzei

INTO TABLE I_IDEMAND

WHERE pbim~werks IN wa_plantsel

AND EXISTS ( SELECT matnr FROM mara

WHERE matnr = pbim~matnr

AND lvorm = '' )

AND EXISTS ( SELECT matnr FROM marc

WHERE marc_{matnr = pbim}matnr

AND marc_{werks = pbim}werks

AND marc~lvorm = '' )

AND pbim~vervs = 'X'

AND pbed~plnmg > 0 .

Former Member — Fri, 01 Sep 2006 04:24:59 GMT

first break the Join ,

first get MATNR from MARA+MARC , then go for Planning data.

Regards

Prabhu

Former Member — Fri, 01 Sep 2006 04:57:24 GMT

Hi,

1. First of all the sequence of fields in select query for PBIM & PBED table should be same as database table.

2. First select the data from mara & marc the fetch data from pbim.

This should solve ur performnace problem .

Regards

Kapil

Former Member — Fri, 01 Sep 2006 05:24:05 GMT

good

use CORRESPONDIG FIELDS OF TABLE statement and see the difference.

thanks

mrutyun