Alternative for Binary Search?

[koushikking]

Hi Experts,

When am reading internal table into work area by using binary search performance is too good, only if it contains numeric values but if internal table contains any alphabetic values search is failing so i just need alternative way to find records without using linear search as internal table contains huge records.

[Former Member]

Binary Search will work even if the key fields are non-numeric. It may be a stupid question, but I hope you are sorting the table by all the search key fields in ascending order before performing the search?

[koushikking]

Key field contain both numeric and non numeric values that time search is failing.

[Szczerbowski]

If it's a READ reference, can't you make this table of type sorted with unique key, or hashed?