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

Reply via email to