Skip to Content
0
Former Member
Mar 27, 2007 at 12:36 PM

Difference vs performance

28 Views

Hi All,

Can any one let me know which of the below code will give more performance.

As you knew that BKPF has 3 primary keys, <b>BUKRS, BELNR and GJAHR.</b> but in the selection screen we have only one selection field that is S_bukrs.

-


Select * from bkpf

into table i_bkpf

where bukrs in s_bukrs.

-


Select * from bkpf

into table i_bkpf

where bukrs in s_bukrs

and belnr in r_belnr [Passing no value]

and gjahr in r_gjahr. [Passing no value]

-


where r_belnr & r_gjahr are ranges - with no value.

Thanks

Jaya