as long as the data truly resides in the file then you should be fine
example I F11:"*":F20[1,4]:"*":F40 etc Rich Israel, John R. wrote:
I have a select that is taking too long. Many of the fields are I-Descs. Some are extracting a piece of info from the file, some are translates to other files, and some are running subroutines. I understand that danger of indexing a translate or subroutine (if the source data changes, the index is not updated). However, I am toying with the idea of building a new I-desc that in some way combines the data in the core file itself. For example, if I need F11 & F20[4,1] and F40, make an I-desc that combines these and then index that I-desc. Just as a sanity check, does this sound like a reasonable thing to do so that I can at least grab a subset of the data I need prior to actually plowing through the translates and subroutines? John _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
-- Richard A Wilson Lakeside Systems Smithfield, RI, USA Voice 401-231-3959 Fax 206-202-2064 _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users