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

Explain the difference between float and packed data type?

762


Describe the data classes?

620


What is the function of a domain?

649


Explain the difference between cluster tables and pool table?

621


What is the difference between tables and structures?

628






What is the significance of the memory table ‘screen’?

605


Explain what is a logical database?

605


What is the difference between a structure and a table? : abap data dictionary

617


hi experts,,, what is meant by documentation? test casr preparation? documentation and preparation and Tcode for this? quality and releasing? test case scenario?

1726


Difference between domain and data element? What are aggregate object?

609


Does the external program run in the same sap luw as the caller, or in a separate one?

659


what precautions or prerequisites do you follow to update a record into database table and how

5260


What are the different functions used in sap script? What are the parameters used in each function?

622


What is locking? : abap data dictionary

635


Table events aNd table maintains generation

994