What is the difference between SEARCH and SEARCH ALL ?
SEARCH - is a serial search.
SEARCH ALL - is a binary search & the table must be sorted ( ASCENDINGDESCENDING KEY clause to be used & data loaded in this order) before using SEARCH ALL.
SEARCH - is a serial search.
SEARCH ALL - is a binary search & the table must be sorted ( ASCENDINGDESCENDING KEY clause to be used & data loaded in this order) before using SEARCH ALL.