I’ve been looking at table indices versus subscripts and can’t help wondering if the better performance of indices is something that might have been a real concern years ago but would be less so today considering improved code optimization by the compiler, and (perhaps) especially so if the subscript is typed as BINARY. For those of you working in the real world are indices still an important technique if you’re just going through a table sequentially?
Related to that, I know that table SEARCHes rely on the use of an index associated with the table, but what if I want to know the subscript of the row that satisfied the test? I guess I could include the row subscript as an actual data element in the structure that defines the row but that seems kinda clunky. Is there perhaps a general way to convert between indices and subscripts?