[U2] Indexing I-Desc

2012-03-06 Thread Israel, John R.
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

Re: [U2] Indexing I-Desc

2012-03-06 Thread Richard A. Wilson
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

Re: [U2] Indexing I-Desc

2012-03-06 Thread Dave Davis
, 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

Re: [U2] Indexing I-Desc

2012-03-06 Thread Israel, John R.
Sounds good. Thanks guys John -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] 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