In an Internal Table, I have 1000 records. I have to Retrieve One Record. In P

Categories >> Software >> ERP CRM >> SAP >> SAP ABAP
Suggest New Category

In an Internal Table, I have 1000 records. I have to
Retrieve One Record. In Performence wise what is the Best
Query?

Question Posted / sunayana

7 Answers
11975 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

In an Internal Table, I have 1000 records. I have to Retrieve One Record. In Performence wise what..

Answer / sathish

Use READ TABLE STATEMENT

READ TABLE <ITAB> INDEX 1.

Is This Answer Correct ?

9 Yes

2 No

In an Internal Table, I have 1000 records. I have to Retrieve One Record. In Performence wise what..

Answer / medepalli.sunil@gmail.com

1.READ TABLE ITAB WITH INDEX F1

2.Loop at itab where f1 and f2

-----

endloop.

out of these two the second has got the best performance
then the first one.

Is This Answer Correct ?

4 Yes

0 No

In an Internal Table, I have 1000 records. I have to Retrieve One Record. In Performence wise what..

Answer / ajay chowdary

READ TABLE ITAB WITH INDEX 1. is the best procedure.

Is This Answer Correct ?

4 Yes

3 No

In an Internal Table, I have 1000 records. I have to Retrieve One Record. In Performence wise what..

Answer / ravi

READ TABLE ITAB INTO WA WITH TABLE KEY F1 F2.. (PROVIDE FULL KEY).

OR

READ TABLE ITAB WITH INDEX 1.

Is This Answer Correct ?

0 Yes

0 No

In an Internal Table, I have 1000 records. I have to Retrieve One Record. In Performence wise what..

Answer / nyk

select *
from <itab>
upto 1 row.

Is This Answer Correct ?

0 Yes

3 No

In an Internal Table, I have 1000 records. I have to Retrieve One Record. In Performence wise what..

Answer / shruthi

select single * is the best query

Is This Answer Correct ?

2 Yes

10 No

In an Internal Table, I have 1000 records. I have to Retrieve One Record. In Performence wise what..

Answer / niladriroy_dgp

Select Single (with full primary key) is the best process
to fetch one record.

Is This Answer Correct ?

2 Yes

13 No

Post New Answer