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

Answer Posted / vijayaraghavan

Select Single * will pickup only one matching record from the database into the buffer, and returns the same to the internal table.

Select upto 1 rows will pickup all the records matching the condition into the buffer, but return the top record to the internal table.

Is This Answer Correct ?    4 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How will you link form with the event driven in sap scripts?

535


What is repository info. Systems?

613


What is exception class and test class. How to use it?

887


What do you do when the system crashes in the middle of a BDC batch session?

695


Example of table cluster and cluster tables.

653






Explain how to Handle the internal tables in ABAP?

643


Can you define a field without a data element?

560


What is a 'z' report?

647


If i wont like to change the standard print program where i copied standard script to customer namespace,in this case is it possible to retreive the data if u connect the script with standard program.if yes how?if no why? Is it possible to print the logo in first page only,where the form consists of 10 pages.How can u do this? How can u set a table format where it cosists of fields like cust no, custname, amount ...in a script? How do u know that the particular BADI is suitable for the existed report.How do u findout this?When do u opt for BADI OR USEREXIT?did functional people tell u to adopt BADI or USEREXIT? What is the difference between SY-INDEX & SY-TABIX ? I have a report with fields Status,time & date. the contents it consists are Status Time Date AAA 01:20:15 05-06-10 AAA 11:02:32 O3-06-10 AAA 23:11:00 05-06-10 AAA 09:14:46 05-06-10 HOW DO U WRITE A CODE TO DISLAY A ROW WHICH WAS RECENTLY EXECUTED?( for this question it should display AAA 23:11:00 05-06-10 AS Output)

2067


Reports: Event functionality.

891


How do you find number of records present in internal table?

577


Have you processed BDCs ?

634


I need some information regarding Vcentric Test pattern ? with questions.

1689


What is the difference between commit-work and rollback-work tasks?

659


What are client dependent objects in abap/sap?

614