Performance

[Former Member]

Hi gurus,

i want to know which is performed better

• SELECT VBELN

FKART

FKTYP

VBTYP

WAERK FROM VBRK INTO TABLE IT_VBRK WHERE FKTYP = '736738' ORDER BY VBTYP.

OR

• SELECT VBELN

FKART

FKTYP

VBTYP

WAERK FROM VBRK INTO TABLE IT_VBRK WHERE FKTYP = '736738' .

SORT IT_VBRK BY I_VBTYP.

Regards

[former_member195383]

2nd one will be better..

coz in the first one...the select query ll take longer time...as u are doing an additional task of sorting....

Reward points...if the ans if helpful

Regards

Rudra

Edited by: Rudra Prasanna Mohapatra on Jun 18, 2008 9:24 AM

[Former Member]

2ed select is better

Edited by: S.r.v.r.Kumar on Jun 18, 2008 12:53 PM

[Former Member]

Hi,

Second select query is better because in the first one sorting has been done at the DATABASE level so it will put more load on the database wheraeas second sorting is at internal table.

Hope it helps you.

Reward if helpful.

[Former Member]

thank you