. Now get Rocket to put
some money into the budget for that.
-Original Message-
From: Brian Leach
To: 'U2 Users List'
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
users-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
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 don'
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
Of Israel, 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 run
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
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 ind
Hey Ross
Excellent article!
Brian
On 15 September 2009 at 17:55 Ross Morrissey 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. The prose is dat
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.pd
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] Ind
: 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
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: www.ol
:53 -0400
> Subject: 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 f
users-boun...@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,
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?
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.
In
nker" <[EMAIL PROTECTED]>
> To: u2-users@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'
> w
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.
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 b
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 -
s UniVerse has two native query languages, but one database engine -
it's available for SQL and non-SQL queries.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of john reid
Sent: Thursday, October 18, 2007 6:26 AM
To: u2-users@listserver.u2ug.
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 o
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 c
PROTECTED]>
To: u2-users@listserver.u2ug.org
Sent: Fri, 11 Mar 2005 13: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...
: u2-users@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 han
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 P
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
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
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.
29 matches
Mail list logo