Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between SEARCH and SEARCH ALL?
- 6 Answers
- 14793 Views
- Cognizant, I also Faced
- E-Mail Answers
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 |
Which is the default, TEST BEFORE or TEST AFTER for a PERFORM statement?
given the following: 77 A PIC 9V9 VALUE 9.5 77 B PIC 9 VALUE 9. 77 C PIC V9 VALUE 0.8 77 D PIC 9 77 E PIC 9 77 F PIC 9V999 what are the contenta of D E nad F after the following statements are executed: COMPUTE F ROUNDED=A+C/B MULTIPLY A BY C GIVING E ADD B C A GIVING D ROUNDED a.F=9.589 E=8 D=1 b.F=9.589 E=8 D=9 c.F=9.589 E=7 D=9 d.F=9.589 E=7 D=1
COMP field occupy ?
how to convert vsam table into DB2 table?
how to resolve the file status 47.......
perform I from 0 by 1 until I=5?How maney times it will executes
What is SQL Code -904 and -903 in DB2 And how to handle it?
what happens of we dont give time stamp in precompilation process
What is file status 92?
Is it possible that the redefines clause has different picture clauses compared to the one it redefined?
i have mainprogram and subgram...if i compile mainprogram without stop run..what will u get in compilation time?
Extract only those records from a PS file which are having word 'TEXT' in the records using COBOL? The word TEXT is not present in a particular position in all the records.
COBOL 
