Unidata 7.3.3 on RedHat: I have a table with numerous indicies built:
File.. H08.CR.COURSE.EVALS
Alternate key length.. 20
Node/Block size... 4K
OV blocks. 1 (0 in use, 0 overflowed)
Indices... 6 (6 D-type)
Index updates. Enabled, No
On 06/12/13 15:08, jeffrey Butera wrote:
Unidata 7.3.3 on RedHat: I have a table with numerous indicies built:
Since these are data fields (nothing computed on-the-fly) and indexed,
queries should be fast.The table has approximately 737,000 records.
This query runs in under 1 second:
: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of jeffrey Butera
Sent: Friday, December 06, 2013 8:09 AM
To: U2 Users List
Subject: [U2] Unidata index/query ?
Unidata 7.3.3 on RedHat: I have a table with numerous indicies built:
File
DAG Consulting
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of jeffrey Butera
Sent: Friday, December 06, 2013 8:09 AM
To: U2 Users List
Subject: [U2] Unidata index/query ?
Unidata 7.3.3 on RedHat: I have
Consulting
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of jeffrey Butera
Sent: Friday, December 06, 2013 8:09 AM
To: U2 Users List
Subject: [U2] Unidata index/query ?
Unidata 7.3.3 on RedHat: I have a table
-boun...@listserver.u2ug.org] On Behalf Of Doug Averch
Sent: Friday, December 06, 2013 9:13 AM
To: U2 Users List
Subject: Re: [U2] Unidata index/query ?
Hi David:
In Unidata indexes DO mean faster selects. I have file with millions of
records with about 14 indexes and most every select on the index
: [U2] Unidata index/query ?
Unidata 7.3.3 on RedHat: I have a table with numerous indicies built:
File.. H08.CR.COURSE.EVALS
Alternate key length.. 20
Node/Block size... 4K
OV blocks. 1 (0 in use, 0 overflowed)
Indices... 6 (6 D-type)
Index updates