what is the difference between select single *
and slect upto 1 rows...
- 3 Answers
- 9095 Views
- I also Faced
- E-Mail Answers
Answer Posted / gohila.r
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.
For this reason, performance wise select upto 1 row is
better than select upto 1 row.
According to SAP Performance course the SELECT UP TO 1 ROWS
is faster than SELECT SINGLE because you are not using all
the primary key fields.
select single is a construct designed to read database
records with primary key. In the absence of the primary key,
it might end up doing a sequential search, whereas the
select up to 1 rows may assume that there is no primary key
supplied and will try to find most suitable index.
The best way to find out is through sql trace or runtime
analysis.
Use "select up to 1 rows" only if you are sure that all the
records returned will have the same value for the field(s)
you are interested in. If not, you will be reading only the
first record which matches the criteria, but may be the
second or the third record has the value you are looking for.
The System test result showed that the variant Single *
takes less time than Up to 1 rows as there is an additional
level for COUNT STOP KEY for SELECT ENDSELECT UP TO 1 ROWS.
The 'SELECT SINGLE' statement selects the first row in the
database that it finds that fulfils the 'WHERE' clause If
this results in multiple records then only the first one
will be returned and therefore may not be unique.
Mainly: to read data from
The 'SELECT .... UP TO 1 ROWS' statement is subtly
different. The database selects all of the relevant records
that are defined by the WHERE clause, applies any aggregate,
ordering or grouping functions to them and then returns the
first record of the result set.
Mainly: to check if entries exist.
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
how to Implement a BADI in which it restricts the access when purchase order is created against contract using definition ME_PURCHDOC_POSTED. please tell me the answers if any one knows. thanks in advance. :ravikiran
What is the differrences between structure and table in data dictionary in abap? : abap hr
what is the t-code to link technical and functional operation?
What is difference between dialog program and a report?
What are the kinds of foreign key fields?
ALV Report that will show the details of order like order no, order date, customer, product code & description, order quantity and value along with the details of dispatch of those orders like invoice no, invoice date, invoice quantity and pending order quantity. plz mention the detail coding Tahnks, Rahul
How do you populate data into a multiple line field?
What are the advantages of logical databases : abap hr
What are the basic objects of the data dictionary? : abap data dictionary
What are the 3 types of function modules in sap?
What are the different types of work process?
When was the sap abap being created?
what is 3 tire architecture and how does SAP utilizes this architecture. and how do netweaver came into picture?
In sap scripts, how will you link form with the event driven?
How many types of tables exists and what are they in data dictionary? : abap data dictionary
