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 read a 100 record from a file through cobol?
In COBOL, what is the different between index and subscript?
0 Answers TryTechnicals Pvt Ltd,
How you can characterize tables in cobol?
What are all the divisions of a COBOL program?
how to transfer the file from pc to mainframe??
What is the maximum data length for Numeric DataType ?
what is label record is standard or omitted in file description of data division?
Write the syntax of a two dimensional array?
How to remove the spaces at end of each record in the output file Via COBOL program? note: The file has a VB length
) How do you access the migrate the data from production region to development region
What type of SDLC u followed? Why?
Hi , I am posting some questons which are asked at interview. These may help u for ur interview... what is static and dynamic call?