iam an entry level cobol professional.i want to know the at what instance should we use index and what instance should we use subscript? when index is more efficient than subscript what for subscript?
The conventional wisdom states that tables w/more than 70 entries should be referenced thru an index. That's the supposed "break even point" where the better speed of indexing exceeds the the additional overhead of its use.
Yes thats true !..Normally if the entries are large then its better if we use index.Let me know if you need more info on this.
Also, if your table is loaded in sequence, and you need to do searches on it, then indexing it is faster since it can then do a binary search instead of scanning through the entire table until if finds the item you are looking for.