Skip to Content
0
Former Member
Jan 03, 2017 at 05:28 PM

Is SELECT * statement selecting all OR only Target fields in SAP HANA v1 ?

437 Views

Hello All,

our system is migrated to HANA and we try to optimize our programs by reducing number of selected table-fields.

Is there a difference in performance between reducing number of selected fields vs number of fields in target (work area, table, etc..)

Please check an example below, is there any difference in speed between query a) and b):

REPORT test.
DATA: BEGIN OF gs_mara,
matnr TYPE matnr.
DATA: END OF gs_mara.
" a)
SELECT * INTO CORRESPONDING FIELDS OF gs_mara
UP TO 1 ROWS
FROM mara.
ENDSELECT.
" b)
SELECT matnr INTO CORRESPONDING FIELDS OF gs_mara
UP TO 1 ROWS
FROM mara.
ENDSELECT.

Thanks and nice 2017 to everyone

Alex.