On 24/05/13 15:57, George Gallen wrote:
> In thinking about itI'm not sure, but it seems to increase the selection
> speed (considerably). It is a type 30 file,
> So possibly the index makes up for a hashing algorithm where the modulo is
> too small? And the makeup of
> The @ID causing more
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Israel, John R.
Sent: Friday, May 24, 2013 8:52 AM
To: U2 Users List
Subject: Re: [U2] UV File doesn't like being sampled?
Maybe I am missing something, but why would you want an index on @ID?
JRI
-Origi
;s working.
George
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Israel, John R.
Sent: Friday, May 24, 2013 11:06 AM
To: U2 Users List
Subject: Re: [U2] UV File doesn't like being sampled?
If you are doin
, May 24, 2013 10:57 AM
To: U2 Users List
Subject: Re: [U2] UV File doesn't like being sampled?
In thinking about itI'm not sure, but it seems to increase the selection
speed (considerably). It is a type 30 file, So possibly the index makes up for
a hashing algorithm where the mod
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Israel, John R.
Sent: Friday, May 24, 2013 10:52 AM
To: U2 Users List
Subject: Re: [U2] UV File doesn't like being sampled?
Maybe I am missing something, but why would you want an index on
ay 24, 2013 10:10 AM
To: U2 Users List
Subject: Re: [U2] UV File doesn't like being sampled?
George, I checked out system and we have experienced this issue before.
Check if you have built an index on @ID. If you have, this is what is causing
your issue. Using the NO.INDEX keyword will give y
l Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen
Sent: Friday, May 24, 2013 10:18 AM
To: U2 Users List
Subject: Re: [U2] UV File doesn't like being sampled?
YUP.
I just isolated it to the index of @ID.
I chang
List
Subject: Re: [U2] UV File doesn't like being sampled?
George, I checked out system and we have experienced this issue before.
Check if you have built an index on @ID. If you have, this is what is causing
your issue. Using the NO.INDEX keyword will give you correct results. I don'
George,
Does the file have an index on the id?
If so, try adding the "NO.INDEX" keyword.
I've something similar @ UV10.2.10:
--
>SELECT PARTS SAMPLE 2
26417 record(s) selected to SELECT list #0.
-
>SELECT PARTS SAMPLE 2 NO.INDEX
2 record(s) selected to SELECT list #0.
-
>DELETE.INDE
goes.
Regards,
Dan McGrath
Managing Director, U2 Servers Lab
Rocket Software
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen
Sent: Friday, May 24, 2013 7:52 AM
To: U2 Users
Subject: [U2] UV File doesn
OK.
Any Ideas? I have a Type 30 file that if I use the SAMPLE modifier in the
SELECT still returns the entire file,
However, if I use the SAMPLE modifier in a LIST command on that same file, it
only returns the sample amount.
Now, it gets stranger, If I do a SELECT with the SAMPLE modifier, it
11 matches
Mail list logo