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
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
WA USA
206 713 6006
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Allen Egerton
Sent: Friday, March 11, 2005 12:08 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Indexing issue
If the primary key is indexed, that's pretty much a waste of time
Try quoting it as 'A12'... instead.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Allen Egerton
Sent: 11 March 2005 20:08
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Indexing issue
From: Dan Knutson [EMAIL PROTECTED]
Sent: Friday, March 11, 2005
@listserver.u2ug.org
Subject: RE: [U2] Indexing issue
Not necessarily so... An index on the primary key will not only allow
you to sort or sselect the file by that key instantly, but also allow
quick selects on partial keys (e.g. select myfile with key = 12345]).
Admittedly esoteric, but on occasion handy.
Scott
:23:17 -0600
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