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
I use something like somestuff:' CODE = A12] ': otherstuff
or as an alternate
somestuff:' CODE = A12 AND A13 ':otherstuff
Works with the index, i.e. fast.
Will Johnson
-Original Message-
From: Dan Knutson [EMAIL PROTECTED]
To: u2-users@listserver.u2ug.org
Sent: Fri, 11 Mar 2005