What are the differences between SELECT SINGLE and UPTO 1 ROWS?
SELECT SINGLE |
UPTO 1 ROWS |
1. It extracts single
record from the data base table |
1. It extracts all the
records into a buffer and moves the first record in to an application program |
2. It doesn’t require
END SELECT statement |
2. It requires END SELECT |
3. Use this one, in case of all key fields
can be considered. To read exact
record from database table we need to provide all key fields. |
3.
Use this one, in case of not possible to use all the key fields. We can read appropriate record from database table; we may
not need to provide all key fields. |
4.
It is slower because it is a construct to read database records with primary key. In the
absence of the primary key, it might end up doing a sequential search |
4. It is faster because you are not using all the primary key fields. |
No comments:
Post a Comment