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 |
what is the difference between occurs and occurs depending on? i dont think so there is the difference in storage..then why we should use occurs depending on?
) How do u handle errors in BMS macro
what is the difference between external and global variables?
How to define a array dynamically.....
consider the following piece of code 01 GROSS-PAY 05 BASIC-PAY PIC 9(5) 05 ALLOWENCES PIC 9(3) if BASIC-PAY has a value 1000 and ALLOWENCES has a value of 250,what will be displayed by the statement DISPLAY GROSS-PAY a.1250 b.01000250 c.01250 d.1.250
how to pass 100 to s9(4) how r they inserted ?
Consider the following code: 77 A PIC 99V99 VALUE 55.35 77 B PIC 99V999 VALUE 32.754 ADD B TO A ON SIZE ERROR DISPLAY "ERROR!!!" What will be the result ? (a) A=88.10, B=32.754 (b) A=87.00 B=32.754 (c) A=87.10 B=32.754 (d) ERROR!!! will be DISPLAYed on the screen.
can we use reference modification an arry.
What is cobol?
What are the differences between COBOL and COBOL II?
For rewrite, why is it mandatory that file needs to be opened?
What is sqlca and why is it needed in any cobol-db2 program?