Re: [U2] Multiple UniData Indexes in same select

2012-11-08 Thread Wols Lists
On 08/11/12 00:47, dennis bartlett wrote: > Once again (I'm a fan of these) the answer is to create a file of composite > keys (FldA * FldB etc) and index that... > > The bummer is that the xref file will always be out unless one adds a > 'trigger' to each 'to be indexed' file Are you SURE? > It

Re: [U2] Multiple UniData Indexes in same select

2012-11-07 Thread dennis bartlett
Once again (I'm a fan of these) the answer is to create a file of composite keys (FldA * FldB etc) and index that... The bummer is that the xref file will always be out unless one adds a 'trigger' to each 'to be indexed' file Itypes can then be created to XLATE the data from the specific files. T

Re: [U2] Multiple UniData Indexes in same select

2012-11-07 Thread Adrian Halid
...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wols Lists Sent: Thursday, 8 November 2012 3:00 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Multiple UniData Indexes in same select On 07/11/12 17:18, Wjhonson wrote: > What about Universe? > imho, it just d

Re: [U2] Multiple UniData Indexes in same select

2012-11-07 Thread Wols Lists
give me a sorted list, so doing a union or intersect of two sorted lists isn't that tricky. Cheers, Wol > > -Original Message- > From: Wally Terhune > To: U2 Users List > Sent: Wed, Nov 7, 2012 9:05 am > Subject: Re: [U2] Multiple UniData Indexes in same select >

Re: [U2] Multiple UniData Indexes in same select

2012-11-07 Thread Doug Farmer
: [U2] Multiple UniData Indexes in same select No on UniBasic SELECTINDEX statement. Not sure I'd call a change made at UniData 5.2 in June of 2000 as 'news'. :-) Wally Terhune Technical Support Engineer Rocket Software 4600 South Ulster Street, Suite 1100 **Denver, CO 80237 **US

Re: [U2] Multiple UniData Indexes in same select

2012-11-07 Thread Wjhonson
What about Universe? -Original Message- From: Wally Terhune To: U2 Users List Sent: Wed, Nov 7, 2012 9:05 am Subject: Re: [U2] Multiple UniData Indexes in same select No on UniBasic SELECTINDEX statement. Not sure I'd call a change made at UniData 5.2 in June of 20

Re: [U2] Multiple UniData Indexes in same select

2012-11-07 Thread Wjhonson
The first one -Original Message- From: Doug Farmer To: U2 Users List Sent: Wed, Nov 7, 2012 6:35 am Subject: [U2] Multiple UniData Indexes in same select Good morning, I should know this, but as the gray gets thicker, some of the old knowledge seeps away. If you have

Re: [U2] Multiple UniData Indexes in same select

2012-11-07 Thread Wally Terhune
are.com **w: u2.rocketsoftware.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dave Laansma Sent: Wednesday, November 07, 2012 9:54 AM To: U2 Users List Subject: Re: [U2] Multiple UniData Indexes in same select

Re: [U2] Multiple UniData Indexes in same select

2012-11-07 Thread Israel, John R.
[U2] Multiple UniData Indexes in same select Good morning, I should know this, but as the gray gets thicker, some of the old knowledge seeps away. If you have indexes on multiple attributes on a file in UniData AND you include both of those indexed attributes in the same Select statement, how d

Re: [U2] Multiple UniData Indexes in same select

2012-11-07 Thread Dave Laansma
ative Solutions" -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wally Terhune Sent: Wednesday, November 07, 2012 11:47 AM To: U2 Users List Subject: Re: [U2] Multiple UniData Indexes in same select >From the Using U

Re: [U2] Multiple UniData Indexes in same select

2012-11-07 Thread Wally Terhune
erh...@rocketsoftware.com **w: u2.rocketsoftware.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Doug Farmer Sent: Wednesday, November 07, 2012 7:35 AM To: U2 Users List Subject: [U2] Multiple UniData Indexes

Re: [U2] Multiple UniData Indexes in same select

2012-11-07 Thread David A. Green
...@listserver.u2ug.org] On Behalf Of Doug Farmer Sent: Wednesday, November 07, 2012 7:35 AM To: U2 Users List Subject: [U2] Multiple UniData Indexes in same select Good morning, I should know this, but as the gray gets thicker, some of the old knowledge seeps away. If you have indexes on multiple attributes on a

[U2] Multiple UniData Indexes in same select

2012-11-07 Thread Doug Farmer
Good morning, I should know this, but as the gray gets thicker, some of the old knowledge seeps away. If you have indexes on multiple attributes on a file in UniData AND you include both of those indexed attributes in the same Select statement, how does UniData know which index to use? Does it u