SEARCH vs SEARCH ALL


SEARCH SEARCH ALL
SEARCH is a linear or sequential search. SEARCH ALL is a binary search.
Should handle index initialization and increment. Only initialization is required for an index. Incrementing is taken care of automatically by the system.
Coding multiple WHEN conditions are allowed and validated. Only one WHEN condition is allowed to code.
Can use arithmetic operators like =, >, <, <=, >=, NOT=. Only = operator is allowed.
Search process is slow. Search process is fast.
SEARCH can be used on single-dimensional and multidimensional tables. SEARCH ALL can be used for only single-dimensional arrays.
Data inside an array need not be in sorted order. Data inside an array should be in a sorted order.