What is the difference between SEARCH and SEARCH ALL?
Answers were Sorted based on User's Feedback
Answer / sharath
SEARCH
1)Linear/sequential search
2)No sorting order because its seq. order
3)access is slow
4)Any relational operator is used
SEARCH ALL
1)Binary search
2)Sorting either asc/dsc order
3)Access is faster
4)Only equal operator can be used.
| Is This Answer Correct ? | 17 Yes | 0 No |
Answer / anil prajapati
search is a sequential/linear search and search all is
binary search
| Is This Answer Correct ? | 10 Yes | 1 No |
Answer / karan
search is linear search. search the data based on condition.
search can work with multiple when conditions.
data is no need sorted order.
when ever we searching the data index clause must be used.
this will take more time compare with search all.
Search all:Binary search.
data must be a sequence either ascending or descending order .
only one when condition can be used.
this will take less time
| Is This Answer Correct ? | 8 Yes | 0 No |
Answer / dev
in addition to the above answer the data to be searched
should be sorted in case of binary search
| Is This Answer Correct ? | 8 Yes | 1 No |
Answer / debby
Search starts at the beginning of the table and searches
each element until the argument is found.
Search All starts mid-point and selects the table partition
to search based on the argument (high or low).
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / pradeep
search:
n search only index can be used
and also multiple when conditions can be used
but coming to binary search
index cannot be used
it searches according to ascending order or des order
here only when codition is possilble
if at all any mistakes can u correct me plssssssss
urs pradeep
| Is This Answer Correct ? | 0 Yes | 0 No |
HOW TO MOVE REDEFINES CLAUSE FROM INPUT TO OUTPUT ?
I have a File that has duplicate records. I need only those records that occur more than thrice.?
How to concatenation one or more string?
What are the steps you go through while creating a COBOL program executable?
what r the types of perform statement
Consider the following: 77 A PIC 9(10) 77 B PIC 9(10) 77 C PIC 9(19) MULTIPLY AB BY B GIVING C Which of the following is true ? (a) The execution of the above may result in size error. (b) The execution of the above will result in size error. (c) The definition of C is invalid resulting in compilation error. (d) No error will be thee and the program would proceed correctly.
How to know whether the module is dynamical or statistical?
TYPES OF SORTINGS. which is more prefarable.
What is amode(24), amode(31), rmode(24) and rmode(any) (applicable to only mvsesa enterprise server) ?
What is a scope terminator? Give examples.
What is Pic 9v99 Indicates in COBOL?
0 Answers SwanSoft Technologies,
How many times the loop runs here 01 a pic 9(2) value 10. perform para1 a times stop run. para1: move 20 to a.