Why sorting is needed for SEARCH ALL

The instant answer is since the search is binary , so the table must be in sorted condition.

Total and maximum you can give 12 keys for SEARCH all table

The total size of all the keys should not exceed 256 bytes.

Also read

Author: Srini

Experienced software developer. Skills in Development, Coding, Testing and Debugging. Good Data analytic skills (Data Warehousing and BI). Also skills in Mainframe.