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?
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