topic Re: Performance in Application Development and Automation Discussions

Performance

Former Member — Wed, 24 Oct 2007 11:34:11 GMT

Hi experts

I am supposed to use the following query, but it affects the performance badly, whats the way to solve this problem, pls help me on the same.

Thanks in advance

Regards

Rajaram

SELECT * FROM bseg

WHERE belnr = p_vblnr

AND gjahr = p_gjahr

AND koart = 'K'

AND bukrs = p_bukrs

AND bschl = '25'.

AND bschl IN ('25','38')

AND augbl NE p_vblnr.

SELECT * FROM bseg "24.09

WHERE belnr = p_vblnr

AND gjahr = p_gjahr

AND koart = 'K'

AND bukrs = p_bukrs

AND bschl = '29'.

Re: Performance

Former Member — Wed, 24 Oct 2007 11:35:48 GMT

avoid nested selects use selecrt for all entries.....

Re: Performance

Former Member — Wed, 24 Oct 2007 11:37:16 GMT

Declare an internal tabel with the fields u actually and add " into table it_table" in your query instead of loading the table with buffered data. this will reduce the load

Re: Performance

Former Member — Wed, 24 Oct 2007 11:37:55 GMT

BUKRS

BELNR

GJAHR

BUZEI

BUZID

AUGDT


SELECT * FROM bseg 
WHERE bukrs = p_bukrs 
and belnr = p_vblnr 
AND gjahr = p_gjahr 
AND augbl NE p_vblnr
AND bschl IN ('25','38') 
AND koart = 'K' . 

SELECT * FROM bseg "24.09 
WHERE AND bukrs = p_bukrs 
and belnr = p_vblnr 
AND gjahr = p_gjahr 
AND bschl = '29'
AND koart = 'K' .

Re: Performance

Former Member — Wed, 24 Oct 2007 11:46:16 GMT

Hi Raja,

1. specify the field names instead of *

2. remove NE comparision in where clause, to avoid those entries do as below

SELECT <f1> <f2> ... FROM bseg into table itab

WHERE belnr = p_vblnr

AND gjahr = p_gjahr

AND koart = 'K'

AND bukrs = p_bukrs

AND bschl = '25'.

AND bschl IN ('25','38').

delete itab where augbl eq p_vblnr.

3. Use secondary indexes.

4. Maintain the fields in the where clause same as the order in database table.

<b>Reward for helpful answers</b>

Satish

Re: Performance

Former Member — Wed, 24 Oct 2007 11:50:56 GMT

still the performance not improved, how can we solve this yar.

Regards

Rajaram

Re: Performance

Former Member — Wed, 24 Oct 2007 11:54:22 GMT

Hi,

I would recommend only a single query & later on filter data .


SELECT * FROM bseg 
WHERE bukrs = p_bukrs 
and belnr = p_vblnr 
AND gjahr = p_gjahr 
AND bschl IN ('25', '29' , '38') 
AND koart = 'K' .

Re: Performance

JozsefSzikszai — Wed, 24 Oct 2007 11:55:09 GMT

form the <i>bschl</i> I see that yoe need vendor items. In this case select from BSIK and BSAK and not from BSEG.

Re: Performance

Former Member — Wed, 24 Oct 2007 12:15:00 GMT

nebtr is not in the bsik or bsak tables.

Regards

Rajaram

Re: Performance

Former Member — Wed, 24 Oct 2007 12:16:00 GMT

no yar these two queries needs to be done two different conditions, so i can't do as you given.

Re: Performance

Former Member — Wed, 24 Oct 2007 12:30:37 GMT

Hi Raja,

Have you amended the chages as i suggested?

Satish