Skip to Content
0
Mar 05, 2009 at 06:27 AM

select * or select (column names) which is better?

1049 Views

Hi Guys,

SELECT * INTO lt_ever FROM ever WHERE vkonto = XXX

OR

SELECT VERTRAG BUKRS SPARTE EIGENVERBR KOFIZ 
PORTION ABSLANFO ABSZYK ABSMNANP GEMFAKT 
MANABR ABRSPERR ABRFREIG VKONTO 
INTO lt_table FROM ever WHERE vkonto = XXX.

Which query is better (performance perspective)?

Is there any documentation available for the same? If yes, please provide doc links.

-

Thanks and Regards,

Nikhil J.

Edited by: Nikhil J. on Mar 5, 2009 12:29 AM