Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Performance

Which one is better performance wise?

Select single * or Read with Binary Search?

Which one will take lesser time?

What are the reasons for that?

Thanks,

Archana.

Tags:
Former Member
Former Member replied

SAP work's on 3 tier arch.

Read take's lesser time than select single why because read statement happens n application layer whereas select single will go to the DB table to fetch data here where condition is important based on which indexes will be used , so if the where cluase contains fields other than key and indexes fields it would take much longer time to fetch.

Note : before doing read binary search sort the itab.

Edited by: karthik arunachalam on Sep 3, 2008 12:00 AM

0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question