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
