Multiple choice technology mainframe

When you have less that 20 elements in a database table, then which among the below is preferred options.

  1. Search

  2. Search All

  3. In-Line Perform

  4. All the above
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

With fewer than 20 elements, an In-Line Perform is more efficient than Search or Search All. In-Line PERFORM eliminates the overhead of setup and search algorithm calls for tiny datasets. Search and Search All add overhead for table scanning and index management that only pays off with larger datasets. 'All the above' is incorrect since they're not equally preferred.

Keep practicing — related questions