From: "Dan Knutson" <[EMAIL PROTECTED]>
Sent: Friday, March 11, 2005 2:23 PM
Subject: [U2] Indexing issue


> I have a file that has thousands of keys that start with an A. There is
> an index on the key. When I try and do a search for any items that start
> with say A12 and I type in A12... the search does not return what I
> expect and takes a long time because Unidata thinks it is doing a
> Alphanumeric search.
> Is there a way to get the results I expect?

If the primary key is indexed, that's pretty much a waste of time.  Indexing
PART of the primary key on the other hand would be useful.  You might
consider creating an I-Type dictionary item that's @ID[1,3], and then
indexing that field.  That would work rather quickly.
-------
u2-users mailing list
[email protected]
To unsubscribe please visit http://listserver.u2ug.org/

Reply via email to