Need some light on using blank ranges in select queries for full key. I know they improve performance...just need to know how because I can't explain it when people ask me how!!!
Or are there any unwanted effects that can't just be spotted by naked eye
SELECT VBELN FROM VBAK INTO TABLE IT_VBAK UP TO 1000 ROWS. GET RUN TIME FIELD START. SELECT * FROM VBAP INTO TABLE IT1 FOR ALL ENTRIES IN IT_VBAK WHERE VBELN = IT_VBAK-VBELN. GET RUN TIME FIELD STOP. ONE = STOP - START. CLEAR: START, STOP. GET RUN TIME FIELD START. SELECT * FROM VBAP INTO TABLE IT2 FOR ALL ENTRIES IN IT_VBAK WHERE VBELN = IT_VBAK-VBELN AND POSNR IN R_POSNR. GET RUN TIME FIELD STOP. TWO = STOP - START.
ONE = 8.
TWO = 3.