Brian:
I was under the impression that UniData uses a real B-Tree indexing
system while UniVerse uses some kind of linked list. e.g. UV has a
single item for, say, male/female and the item would look like
ID: male
001 1]2]3]4]5]6]...]999
...which would perform exactly as you say. I
-boun...@listserver.u2ug.org] On Behalf Of Bill Haskett
Sent: 05 October 2012 17:15
To: U2 Users List
Subject: Re: [U2] Consuming Web Services (U2 Indexing)
Brian:
I was under the impression that UniData uses a real B-Tree indexing system
while UniVerse uses some kind of linked list. e.g. UV has
into the budget for that.
-Original Message-
From: Brian Leach br...@brianleach.co.uk
To: 'U2 Users List' u2-users@listserver.u2ug.org
Sent: Fri, Oct 5, 2012 9:25 am
Subject: Re: [U2] Consuming Web Services (U2 Indexing)
Bill
I *did* say UniVerse specific :)
Yes, it uses a really nice and well
I have a select that is taking too long. Many of the fields are I-Descs. Some
are extracting a piece of info from the file, some are translates to other
files, and some are running subroutines.
I understand that danger of indexing a translate or subroutine (if the source
data changes, the
as long as the data truly resides in the file then you should be fine
example
I
F11:*:F20[1,4]:*:F40
etc
Rich
Israel, John R. wrote:
I have a select that is taking too long. Many of the fields are I-Descs. Some
are extracting a piece of info from the file, some are translates to other
, John R.
Sent: Tuesday, March 06, 2012 1:41 PM
To: 'U2 Users List'
Subject: [U2] Indexing I-Desc
I have a select that is taking too long. Many of the fields are I-Descs. Some
are extracting a piece of info from the file, some are translates to other
files, and some are running subroutines.
I
Sounds good.
Thanks guys
John
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dave Davis
Sent: Tuesday, March 06, 2012 1:51 PM
To: U2 Users List
Subject: Re: [U2] Indexing I-Desc
As long as all the data comes
I just tried it on 10.2.4 or UV and it works!
Jerry Banker
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Henry Unger
Sent: Monday, September 14, 2009 8:55 PM
To: 'U2 Users List'
Subject: Re: [U2] Indexing
Yes
It's not IBM technical documentation, but several years ago I published a
number of push the envelope techniques for UniVerse Secondary Indexes in
an article for the OSDA Newsletter. The prose is dated, but the techniques
aren't. It's at: http://www.rossmorrissey.com/uv/rossmorrissey_indexes.pdf
Hey Ross
Excellent article!
Brian
On 15 September 2009 at 17:55 Ross Morrissey u...@rossmorrissey.com wrote:
It's not IBM technical documentation, but several years ago I published a
number of push the envelope techniques for UniVerse Secondary Indexes in
an article for the OSDA Newsletter.
I seem to recall that they added the CONCURRENT option to BUILD.INDEX
several years back but didn't document it except in the patch file for
that release.
Does anyone else remember this?
Regards,
Clif
--
W. Clifton Oliver, CCP
CLIFTON OLIVER ASSOCIATES
Tel: +1 619 460 5678Web:
: Monday, September 14, 2009 4:26 PM
To: U2 Users List
Subject: Re: [U2] Indexing
I seem to recall that they added the CONCURRENT option to BUILD.INDEX
several years back but didn't document it except in the patch file for
that release.
Does anyone else remember this?
Regards,
Clif
--
W
I am not a UV newbie by any means, but I've never used indexing, and I
need to know where to start, with reading to gain some knowledge on the
documentation.
Any particular area of the IBM technical documentation that might be
particularly helpful to this noob to the wide world of indexing?
...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bessel, Karen
Sent: Wednesday, September 09, 2009 5:24 PM
To: u2-users@listserver.u2ug.org
Subject: [U2] Indexing
I am not a UV newbie by any means, but I've never used indexing, and I
need to know where to start, with reading to gain
: Re: [U2] Indexing
System Description, chapter 4, starting on page 22.
Be sure to get what NO.NULLS does; if you have a lot of fields with null
values, it makes your index lopsided and much less effective. Also, note
that each index on a file increases your writes by 1. We see a significant
Isn't that true only when using 'AND' with the 'WITH' phrase? Using 'OR'
would have to use the whole index/selection again.
-Original Message-
From: Ray Wurlod [mailto:[EMAIL PROTECTED]
Sent: Saturday, October 20, 2007 11:30 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Indexing
@listserver.u2ug.org
Subject: RE: [U2] Indexing Optimization
Date: Mon, 22 Oct 2007 08:02:37 -0500
Isn't that true only when using 'AND' with the 'WITH' phrase? Using 'OR'
would have to use the whole index/selection again.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit
So, Ray, where do I find these rules? Are they written down somewhere
that I can get to and acquire a copy?
Jef.
- Partial Original Message-
No, it's true for all cases. UniVerse indexes are only used on
restrictions in the first WITH phrase in the query. That's one of the
rules.
One of the rules for UniVerse to use an index is that the restriction occurs in
the first WITH phrase. The reasoning is that the majority of records to be
excluded will have been excluded by the first WITH clause, and that therefore
the second WITH clause need only examine the record selected
FYI...
This link has a nice summary of what the major RDBMS offer for the
EXPLAIN output:
http://www.aquafold.com/docs-ep-plan.html
It would be nice to have a version of Aquafold (or one of the many
similar multi-OS and multi-database 'aware' toolsets) available for
UniVerse too...ah, one day
Could someone please explain the EXPLAIN results? The Help does not
show about EXPLAIN.
In particular, what does the index processing point out? I have 43,000
records that have A8=DRJ but only a handful that will have A50=70 so
if I can get the SELECT to use A50 first that would be great. I can
It appears that 'EXPLAIN' is somewhat documented via an internet
search, implying that it might be standard equipment for at least some
SQL's in order to show query plans. I did find a file on our system
named SQL.HELP. A search revealed 6 records containing 'EXPLAIN' but
it also contained a lot
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
28 matches
Mail list logo