Sounds good.

Thanks guys


-----Original Message-----
[] On Behalf Of Dave Davis
Sent: Tuesday, March 06, 2012 1:51 PM
To: U2 Users List
Subject: Re: [U2] Indexing I-Desc

As long as all the data comes from the record and/or id itself, you should be 
fine.  You can get into trouble if it comes from another record in the same 
file or another file entirely, although it can be done if the other file 
contains "stable" data - a word index for example, where you have a secondary 
file that contains words that are not included in the index, and the list is 
updated with all the dependent indices as part of a maintenance routine.

-----Original Message-----
[] On Behalf Of Israel, John R.
Sent: Tuesday, March 06, 2012 1:41 PM
To: 'U2 Users List'
Subject: [U2] Indexing I-Desc

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?

U2-Users mailing list

Dave Davis
Team Lead, R&D

P: 614-875-4910 x108
F: 614-875-4088

        6110 Enterprise Parkway
Grove City, OH

This message is intended exclusively for the individual or entity to which it 
is addressed. This communication may contain information that is proprietary, 
privileged or confidential or otherwise legally exempt from disclosure. If you 
are not the named addressee, you are not authorized to read, print, retain, 
copy or disseminate this message or any part of it. If you have received this 
message in error, please notify the sender immediately by e-mail and delete all 
copies of the message.

U2-Users mailing list

U2-Users mailing list

Reply via email to