Skip to Content
0
Apr 30, 2014 at 11:40 AM

Performance Impact on SELECT to VIEW

942 Views

Dear Experts,

Is there any performance impact when we select to a database view? Should we use JOIN or FAE instead?

according to this wiki:

http://wiki.scn.sap.com/wiki/display/ABAP/ABAP+Performance+and+Tuning

At point 1.j. it is stated that there's no performance impact.

But trying myself to get the number of entries select from SE16N (by pressing F7) to table COVP (view) comparing to COEP resulting:

COVP approximately takes 3 seconds

COEP approximately takes 1 second

If it is better to SELECT to a view, can we use the underlying table index?

Thank you,

Suwandi C.