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 different between variable length and fixed length?
What is a SSRANGE and NOSSRANGE?
In A cobol program , we can use COPY Statement in FILE- SECTION / WORKING-STORAGE SECTION / ENVIRONMENT DIVIION basically what is the difference
How To move a value to an array using move verb?
I have a occurs for 100 times but it has executed 101 time what could be the reason?
How to retrive the 9th records out of ten records using the cobol program ?
what is internal sort and external sort ? which is preferable ?
Should I use STOP RUN in the sub program??why?
What should be the sorting order for SEARCH ALL?
What is perform what is varying?
For rewrite, why is it mandatory that file needs to be opened?
what is index and how to use two tables using index?