Wat is the difference between Select single * and Select ..
Up to one row . And which method is better for performance ?

Answer Posted / stefan wagenblast

As looking on the performance analysis (ST05), both SELECTs
have the same estimated costs (I made a test). So because
estimated costs com from the database system, the same way
of searching in the table will be used --> no difference
which SELECT you use.

Is This Answer Correct ?    1 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to read files and process BDC's automatically ?

1633


What are the names of the function modules that will be generated upon activation of a lock object?

550


Does every abap/4 have a modular structure?

559


What are the layers of data description in r/3? : abap data dictionary

642


What is SAP Data conversion ?

634






What are the different modes of processing batch input sessions? : abap bdc

657


Can we control the sequence in which multiple implementations of a multiple use BADI are called? If yes, how?

915


What are the three hierarchical levels of data types and objects?

581


What is your current client number?

593


Can we use write statements in screen fields?if not how is data transferred from field data to screen fields?

555


Name the abap/4 modularization techniques? : abap modularization

649


Can i have some Realtime Scenarios on Reports.

1815


Is logo in script 1st stored as tiff format before uploading or in jpeg format?and where is that stored after uploading?

1598


What are system fields for secondary lists?

613


In the MM module for finding out the standard cost what is the view one has to look at?

618