topic Re: Comparision between two different approach in Application Development and Automation Discussions

Comparision between two different approach

Former Member — Mon, 04 May 2009 07:32:11 GMT

Hi all ,

Please let me know which of the below will be good in terms of performance :

1. SELECT VBELN ERNAM ERDAT VSTEL KUNNR

FROM LIKP

INTO TABLE I_LIKP

WHERE VSTEL IN S_VSTEL

AND LFART IN S_LFART

AND WADAT_IST = 0.

And

2. CONSTANTS: gc_erdat TYPE erdat VALUE IS INITIAL.

SELECT VBELN ERNAM ERDAT VSTEL KUNNR

FROM LIKP

INTO TABLE I_LIKP

WHERE VSTEL IN S_VSTEL

AND erdat GE gc_erda

AND LFART IN S_LFART

AND WADAT_IST = 0.

Also, provide reason for the same.

Thanks in Advance.

VSTEL , ERDAT And LFART are fields in secondary index.

Former Member — Mon, 04 May 2009 07:47:41 GMT

you should not ask such questions, they make no sense,

Write a small report, with


get runtime field start 
 ...
 get runtime field stop.

t = stop - start.

and measure them both, run the SQL Trace.

Result depends to a large extent on the data distribution ... OF YOUR SYSTEM.

Siegfried

Former Member — Mon, 04 May 2009 12:25:10 GMT

Hi:

SELECT VBELN ERNAM ERDAT VSTEL KUNNR

FROM LIKP

INTO TABLE I_LIKP

WHERE VSTEL IN S_VSTEL

AND erdat GE gc_erda

AND LFART IN S_LFART

AND WADAT_IST = 0.

Is the best, since we should avoid hard cording and more filteration as much as possible

Regards

Shashi