please clear this what is the diff b/w select single * and
select up to 1 row?
- 5 Answers
- 7044 Views
- I also Faced
- E-Mail Answers
Answer Posted / prasad
Select single * query will retrieve all the records from
the database table with respect to the condition specified
and finally select one single row among the retrieved.
In case of Select up to 1 row,the query starts retrieving
the database and once it gets the 1 row w.r.t its condition
it stops further retrieval.Performancewise using select
single * is not gud.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is a table pool?
What statement will be found in an sap application program that implements a function module exit?
What is ole?
Is it possible to bring select option in module pool screens?
What is sap luw or update transaction?
What is update task
Does the bdc-insert function allow multiple transactions to be processed by sap? : abap bdc
Explain badi in abap.
performance tuning concepts
How can we declare a table control in the abap/4 program?
What is the difference between sum and collect?
Sy index and sy tabix
did u done enhancement framework?how u implemented?
What is the functionality of BIZTALK and how it handles the IDOC’s and how u will transfer the IDOCS to the BIZTALK ?
What is the difference between field-group header and other field groups? : abap modularization
