Search This Blog

Tuesday, August 09, 2005

Select count(*) is faster then Select single

SE30 analysis:

SELECT count(*) FROM bkpf WHERE bukrs = s_trans-bukrs AND
belnr = s_trans-belnr AND
gjahr = s_trans-gjahr AND
stblg = space.

vs

SELECT single * FROM bkpf WHERE bukrs = s_trans-bukrs AND
belnr = s_trans-belnr AND
gjahr = s_trans-gjahr AND
stblg = space.

2 comments:

Jason D said...

Lets see the runtime results...

Dfloth said...

917 microsec vs 1,521 microsec