View previous topic :: View next topic
|
Author |
Message |
nagireddynarva
New User
Joined: 30 Apr 2005 Posts: 5 Location: hyderabad
|
|
|
|
hi,
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?
cheers..
|
|
Back to top |
|
|
mmwife
Super Moderator
Joined: 30 May 2003 Posts: 1592
|
|
|
|
Hi,
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. |
|
Back to top |
|
|
brain_s390
New User
Joined: 06 May 2005 Posts: 58 Location: Mumbai
|
|
|
|
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. |
|
Back to top |
|
|
dbelton
New User
Joined: 10 Jun 2005 Posts: 15
|
|
|
|
brain_s390 wrote: |
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. |
|
Back to top |
|
|
|