So if each one has at most five multi-values, and you want the more recent three, you will be selecting at a minimum 60% of the file's entries. For that purposes an index is the *wrong* structure to use :)
The most efficient search is strictly linear... group order. So just a simple SSELECT... WHEN... -----Original Message----- From: Lunt, Bruce <bl...@shaklee.com> To: U2 Users List <u2-users@listserver.u2ug.org> Sent: Tue, Aug 27, 2013 10:59 am Subject: Re: [U2] UDT 7.1 Indexing question Each record has 2-5 multi-values that are date periods. I am looking for the most recent 3 periods. There are over a million records so the BY-EXP gives me 3 million values to process. I thought about writing a work file with the values in a separate record but the size seems like it would take forever to do and then I would still need to create the report from the work file's 3 million records. -----Original Message----- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dave Davis Sent: Tuesday, August 27, 2013 10:52 AM To: U2 Users List Subject: Re: [U2] UDT 7.1 Indexing question It really depends on the percentage of records that contain the value you are looking for - multivalued or not I think if you include a criteria like: WITH mv_indexed_field = "value" it will be faster than without the index. However, if most of the records in the file have that value it won't make much difference. -----Original Message----- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Lunt, Bruce Sent: Tuesday, August 27, 2013 1:46 PM To: U2 Users List Subject: Re: [U2] UDT 7.1 Indexing question That's what I was afraid of. I have a large file and I was looking for some way to speed up a report that I am creating with Uniquery. -----Original Message----- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King Sent: Tuesday, August 27, 2013 10:43 AM To: U2 Users List Subject: Re: [U2] UDT 7.1 Indexing question My guess is that it shouldn't matter. Each multivalue in a list gets a separate index entry. On Tue, Aug 27, 2013 at 10:46 AM, Lunt, Bruce <bl...@shaklee.com> wrote: > Hi All, > > Will indexing a field that I retrieve with BY-EXP be faster than an > un-indexed field? > > Thanks, > Bruce > _______________________________________________ > U2-Users mailing list > U2-Users@listserver.u2ug.org > http://listserver.u2ug.org/mailman/listinfo/u2-users > _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ________________________________ Dave Davis Team Lead, Research & Development P: 614-875-4910 x108 F: 614-875-4088 E: dda...@harriscomputer.com [http://www.harriscomputer.com/images/signatures/HarrisSchools.jpg] [http://www.harriscomputer.com/images/signatures/DivisionofHarris.gif]<http://www.harriscomputer.com/> 6110 Enterprise Parkway Grove City, OH 43123 www.harris-schoolsolutions.com<http://www.harris-schoolsolutions.com> 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@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
