Re: [U2] Indexing I-Desc
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 files, and some are running subroutines. I understand that danger of indexing a translate or subroutine (if the source data changes, the index is not updated). However, I am toying with the idea of building a new I-desc that in some way combines the data in the core file itself. For example, if I need F11 F20[4,1] and F40, make an I-desc that combines these and then index that I-desc. Just as a sanity check, does this sound like a reasonable thing to do so that I can at least grab a subset of the data I need prior to actually plowing through the translates and subroutines? John ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- Richard A Wilson Lakeside Systems Smithfield, RI, USA Voice 401-231-3959 Fax 206-202-2064 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Indexing I-Desc
As long as all the data comes from the record and/or id itself, you should be fine. You can get into trouble if it comes from another record in the same file or another file entirely, although it can be done if the other file contains stable data - a word index for example, where you have a secondary file that contains words that are not included in the index, and the list is updated with all the dependent indices as part of a maintenance routine. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf 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 running subroutines. I understand that danger of indexing a translate or subroutine (if the source data changes, the index is not updated). However, I am toying with the idea of building a new I-desc that in some way combines the data in the core file itself. For example, if I need F11 F20[4,1] and F40, make an I-desc that combines these and then index that I-desc. Just as a sanity check, does this sound like a reasonable thing to do so that I can at least grab a subset of the data I need prior to actually plowing through the translates and subroutines? John ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users Dave Davis Team Lead, RD P: 614-875-4910 x108 F: 614-875-4088 E: dda...@harriscomputer.com [http://www.harriscomputer.com/images/signatures/HarrisSchools.gif] [http://www.harriscomputer.com/images/signatures/DivisionofHarris.gif]http://www.harriscomputer.com/ 6110 Enterprise Parkway Grove City, OH 43123 www.harris-schoolsolutions.comhttp://www.harris-schoolsolutions.com This message is intended exclusively for the individual or entity to which it is addressed. This communication may contain information that is proprietary, privileged or confidential or otherwise legally exempt from disclosure. If you are not the named addressee, you are not authorized to read, print, retain, copy or disseminate this message or any part of it. If you have received this message in error, please notify the sender immediately by e-mail and delete all copies of the message. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Indexing I-Desc
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 from the record and/or id itself, you should be fine. You can get into trouble if it comes from another record in the same file or another file entirely, although it can be done if the other file contains stable data - a word index for example, where you have a secondary file that contains words that are not included in the index, and the list is updated with all the dependent indices as part of a maintenance routine. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf 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 running subroutines. I understand that danger of indexing a translate or subroutine (if the source data changes, the index is not updated). However, I am toying with the idea of building a new I-desc that in some way combines the data in the core file itself. For example, if I need F11 F20[4,1] and F40, make an I-desc that combines these and then index that I-desc. Just as a sanity check, does this sound like a reasonable thing to do so that I can at least grab a subset of the data I need prior to actually plowing through the translates and subroutines? John ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users Dave Davis Team Lead, RD P: 614-875-4910 x108 F: 614-875-4088 E: dda...@harriscomputer.com [http://www.harriscomputer.com/images/signatures/HarrisSchools.gif] [http://www.harriscomputer.com/images/signatures/DivisionofHarris.gif]http://www.harriscomputer.com/ 6110 Enterprise Parkway Grove City, OH 43123 www.harris-schoolsolutions.comhttp://www.harris-schoolsolutions.com This message is intended exclusively for the individual or entity to which it is addressed. This communication may contain information that is proprietary, privileged or confidential or otherwise legally exempt from disclosure. If you are not the named addressee, you are not authorized to read, print, retain, copy or disseminate this message or any part of it. If you have received this message in error, please notify the sender immediately by e-mail and delete all copies of the message. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Indexing
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 indeed, however it was removed. Hopefully, it will reappear. Best regards, Henry Henry P. Unger Hitech Systems, Inc. http://www.hitech.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Clifton Oliver Sent: 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. Clifton Oliver, CCP CLIFTON OLIVER ASSOCIATES Tel: +1 619 460 5678Web: www.oliver.com On Sep 9, 2009, at 2:43 , Dan Fitzgerald wrote: Building indices means exclusive locks on the file, i.e., downtime. The good news is that the builds are usually very quick. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Indexing
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 On Wed, Sep 9, 2009 at 2:24 PM, Bessel, Karen karen.bes...@tylertech.comwrote: 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? Thanks! Karen Bessel Software Developer Tyler Technologies, Inc. 6500 International Parkway, Suite 2000 Plano, TX 75093 Phone: 972.713.3770 ext:6227 Fax: 972.713.3780 Email: karen.bes...@tylertech.com Web: http://www.tylertech.com Tyler is proud to be the Platinum Sponsor of The Court Technology Conference 2009 Sept. 22-24, 2009 | Denver, CO ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Indexing
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. The prose is dated, but the techniques aren't. It's at: http://www.rossmorrissey.com/uv/rossmorrissey_indexes.pdf On Wed, Sep 9, 2009 at 2:24 PM, Bessel, Karen karen.bes...@tylertech.comwrote: 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? Thanks! Karen Bessel Software Developer Tyler Technologies, Inc. 6500 International Parkway, Suite 2000 Plano, TX 75093 Phone: 972.713.3770 ext:6227 Fax: 972.713.3780 Email: karen.bes...@tylertech.com Web: http://www.tylertech.com Tyler is proud to be the Platinum Sponsor of The Court Technology Conference 2009 Sept. 22-24, 2009 | Denver, CO ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
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. Clifton Oliver, CCP CLIFTON OLIVER ASSOCIATES Tel: +1 619 460 5678Web: www.oliver.com On Sep 9, 2009, at 2:43 , Dan Fitzgerald wrote: Building indices means exclusive locks on the file, i.e., downtime. The good news is that the builds are usually very quick. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Indexing
Yes indeed, however it was removed. Hopefully, it will reappear. Best regards, Henry Henry P. Unger Hitech Systems, Inc. http://www.hitech.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Clifton Oliver Sent: 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. Clifton Oliver, CCP CLIFTON OLIVER ASSOCIATES Tel: +1 619 460 5678Web: www.oliver.com On Sep 9, 2009, at 2:43 , Dan Fitzgerald wrote: Building indices means exclusive locks on the file, i.e., downtime. The good news is that the builds are usually very quick. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
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 throughput hit after 5 or 6 indices on a file. Also, compound selects are often less efficient than actually doing multiple selects. Building indices means exclusive locks on the file, i.e., downtime. The good news is that the builds are usually very quick. -Original Message- From: u2-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, 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? Thanks! Karen Bessel Software Developer Tyler Technologies, Inc. 6500 International Parkway, Suite 2000 Plano, TX 75093 Phone: 972.713.3770 ext:6227 Fax: 972.713.3780 Email: karen.bes...@tylertech.com Web: http://www.tylertech.com Tyler is proud to be the Platinum Sponsor of The Court Technology Conference 2009 Sept. 22-24, 2009 | Denver, CO ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Indexing
And System Description, chapter 7 (aka IBM doc 25126370.pdf) CREATE.INDEX BUILD.INDEX DELETE.INDEX LIST.INDEX ENABLE.INDEX DISABLE.INDEX SELECTINDEX no more than 3 per file is better. From: dangf...@hotmail.com To: u2-users@listserver.u2ug.org Date: Wed, 9 Sep 2009 17:43: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 file increases your writes by 1. We see a significant throughput hit after 5 or 6 indices on a file. Also, compound selects are often less efficient than actually doing multiple selects. Building indices means exclusive locks on the file, i.e., downtime. The good news is that the builds are usually very quick. -Original Message- From: u2-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, 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? Thanks! Karen Bessel Software Developer Tyler Technologies, Inc. 6500 International Parkway, Suite 2000 Plano, TX 75093 Phone: 972.713.3770 ext:6227 Fax: 972.713.3780 Email: karen.bes...@tylertech.com Web: http://www.tylertech.com Tyler is proud to be the Platinum Sponsor of The Court Technology Conference 2009 Sept. 22-24, 2009 | Denver, CO ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users _ Windows Live: Keep your friends up to date with what you do online. http://windowslive.com/Campaign/SocialNetworking?ocid=PID23285::T:WLMTAGL:ON:WL:en-US:SI_SB_online:082009 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
RE: [U2] Indexing Optimization
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 Optimization 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 by the first WITH clause. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Indexing Optimization
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. Indexes are used except: 1. if the NO.INDEX keyword is specified 2. if an active Select List can be used (similar logic to current thread) 3. if the restriction is in other than the first WITH clause 4. if there is an OR conjunction with a non-indexed field 5. if will satisfy the restriction (for example a or restriction) and the index is NO.NULLS 6. if the restriction on an indexed field follows a restriction on a non-indexed field in an AND conjunction (this can be re-ordered to get the index used, but is not re-ordered by the query optimizer) An index may also be used if the query is sorted on the indexed field and not constrained. - Original Message - From: Jerry Banker [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' would have to use the whole index/selection again. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Indexing Optimization
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. Indexes are used except: 1. if the NO.INDEX keyword is specified 2. if an active Select List can be used (similar logic to current thread) 3. if the restriction is in other than the first WITH clause 4. if there is an OR conjunction with a non-indexed field 5. if will satisfy the restriction (for example a or restriction) and the index is NO.NULLS 6. if the restriction on an indexed field follows a restriction on a non-indexed field in an AND conjunction (this can be re-ordered to get the index used, but is not re-ordered by the query optimizer) An index may also be used if the query is sorted on the indexed field and not constrained. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Indexing Optimization
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 by the first WITH clause. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Indexing Optimization
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 - perhaps! Although there is a Generic ODBC/JDBC option (like similar tools). Although, I wouldn't say they'd be a huge demand for this sort of tool in the U2 environment. Regards, David --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Indexing Optimization
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 of repetition. There was no occurrence in SYS.HELP that I found. The EXPLAIN seemed to show the same thing whether I used a Universe uniquery or an SQL statement, given the same search criteria. On 10/17/07, Jef Lee [EMAIL PROTECTED] wrote: 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 see that additional WITHs make a difference but is the order in the command significant? Also is there anything undocumented like EXPLAIN that will tell me how long a TCL command takes to execute? The file is indexed as follows: LIST.INDEX GLDET A8 A9 A50 A72 Alternate Key Index Summary for file GLDET File... GLDET Indices 3 (0 A-type, 0 C-type, 3 D-type, 0 I-type, 0 SQL, 0 S-type) Index Updates.. Enabled, No updates pending Index name Type BuildNulls In DICT S/M Just Unique Field num/I-type A8 DNot Reqd No Yes SL N8 A9 DNot Reqd No Yes SL N9 A50 DNot Reqd No Yes SL N50 A72 is not a secondary index field. I run this SELECT statement: SELECT GLDET WITH A50=70 AND A9=INV AND A8=DRJ AND A72=G BY.DSND A2 BY. DSND A10 BY @ID EXPLAIN Single-variable predicates processed in index: F8 = 'DRJ' AND (F50 = '70' AND F9 = 'INV') Optimizing query block 0 Tuple restriction: F72 = 'G' AND TRUE Driver source: GLDET Access method: select list 0 with 0 ids Sorted by: [EMAIL PROTECTED] UniVerse/SQL: Press any key to continue or 'Q' to quit 0 record(s) selected to SELECT list #0. Then if I change the SELECT by adding another WITH:- SELECT GLDET WITH A50=70 AND WITH A9=INV AND A8=DRJ AND A72=G BY.DSND A2 BY.DSND A10 BY @ID EXPLAIN Single-variable predicates processed in index: F50 = '70' AND (F9 = 'INV' AND F8 = 'DRJ') Optimizing query block 0 Tuple restriction: F72 = 'G' AND TRUE Driver source: GLDET Access method: select list 0 with 0 ids Sorted by: [EMAIL PROTECTED] UniVerse/SQL: Press any key to continue or 'Q' to quit 0 record(s) selected to SELECT list #0. Then if I change the SELECT by adding more WITHs:- SELECT GLDET WITH A50=70 AND WITH A9=INV AND WITH A8=DRJ AND WITH A72=G BY.DSND A2 BY.DSND A10 BY @ID EXPLAIN Single-variable predicates processed in index: F8 = 'DRJ' AND (F50 = '70' AND F9 = 'INV') Optimizing query block 0 Tuple restriction: F72 = 'G' AND TRUE Driver source: GLDET Access method: select list 0 with 0 ids Sorted by: [EMAIL PROTECTED] UniVerse/SQL: Press any key to continue or 'Q' to quit 0 record(s) selected to SELECT list #0. Thanks, Jeffrey Lee Senior Analyst/Programmer IT Vision Australia Pty Ltd (ABN: 34 309 336 904) PO Box 881, Canning Bridge WA 6153 Level 3, Kirin Centre, 15 Ogilvie Road, Applecross, WA, 6153 P: (08) 9315 7000F: (08) 9315 7088 W: http://www.itvision.com.au http://www.itvision.com.au ___ NOTICE : This e-mail and any attachments are intended for the addressee(s) only and may contain confidential or privileged material. Any unauthorised review, use, alteration, disclosure or distribution of this e-mail (including any attachments) by an unintended recipient is prohibited. If you are not the intended recipient please contact the sender as soon as possible by return e-mail and then delete both messages. ___ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ -- john --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Indexing issue
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 does not return what I expect and takes a long time because Unidata thinks it is doing a Alphanumeric search. Is there a way to get the results I expect? If the primary key is indexed, that's pretty much a waste of time. Indexing PART of the primary key on the other hand would be useful. You might consider creating an I-Type dictionary item that's @ID[1,3], and then indexing that field. That would work rather quickly. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
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 Ballinger Pareto Corporation Edmonds 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. Indexing PART of the primary key on the other hand would be useful. You might consider creating an I-Type dictionary item that's @ID[1,3], and then indexing that field. That would work rather quickly. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Indexing issue
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 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 does not return what I expect and takes a long time because Unidata thinks it is doing a Alphanumeric search. Is there a way to get the results I expect? If the primary key is indexed, that's pretty much a waste of time. Indexing PART of the primary key on the other hand would be useful. You might consider creating an I-Type dictionary item that's @ID[1,3], and then indexing that field. That would work rather quickly. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ The information contained in this email is strictly confidential and for the use of the addressee only, unless otherwise indicated. If you are not the intended recipient, please do not read, copy, use or disclose to others this message or any attachment. Please also notify the sender by replying to this email or by telephone +44 (0)20 7896 0011 and then delete the email and any copies of it. Opinions, conclusions (etc.) that do not relate to the official business of this company shall be understood as neither given nor endorsed by it. IG Markets Limited and IG Index Plc are authorised and regulated by the Financial Services Authority and, in Australia, by the Australian Securities and Investments Commission. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Indexing issue
My problem seems to be that Unidata see's the A and thinks I am doing a alphanumeric search on everything after the A. It takes the A as a command to do an alphanumeric search. I was told you could put quotes around the criteria to get it to work right but so far I have not been able to do that. Daniel Knutson OSTech Client Support www.epicor.com Tel.: (800) 347-2381 Fax: (800) 764-4539 E-Mail: [EMAIL PROTECTED] 600 South HWY 169 2000 Interchange Tower, Minneapolis, MN 55426 This e-mail is for the use of the intended recipient(s) only. If you have received this e-mail in error, please notify the sender immediately and then delete it. If you are not the intended recipient, you must not use, disclose or distribute this e-mail without the author's prior permission. We have taken precautions to minimize the risk of transmitting software viruses, but we advise you to carry out your own virus checks on any attachment to this message. We cannot accept liability for any loss or damage caused by software viruses. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Scott Ballinger Sent: Friday, March 11, 2005 2:43 PM To: 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 handy. Scott Ballinger Pareto Corporation Edmonds 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. Indexing PART of the primary key on the other hand would be useful. You might consider creating an I-Type dictionary item that's @ID[1,3], and then indexing that field. That would work rather quickly. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ This e-mail is for the use of the intended recipient(s) only. If you have received this e-mail in error, please notify the sender immediately and then delete it. If you are not the intended recipient, you must not use, disclose or distribute this e-mail without the author's prior permission. We have taken precautions to minimize the risk of transmitting software viruses, but we advise you to carry out your own virus checks on any attachment to this message. We cannot accept liability for any loss or damage caused by software viruses. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Indexing issue
I use something like somestuff:' CODE = A12] ': otherstuff or as an alternate somestuff:' CODE = A12 AND A13 ':otherstuff Works with the index, i.e. fast. Will Johnson -Original Message- From: Dan Knutson [EMAIL 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... the search does not return what I expect and takes a long time because Unidata thinks it is doing a Alphanumeric search. Is there a way to get the results I expect? ** This email message and any files transmitted with it are confidential and intended solely for the use of addressed recipient(s). If you have received this email in error please notify the Spotless IS Support Centre (61 3 9269 7555) immediately who will advise further action. This footnote also confirms that this email message has been scanned for the presence of computer viruses. ** --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ This e-mail is for the use of the intended recipient(s) only. If you have received this e-mail in error, please notify the sender immediately and then delete it. If you are not the intended recipient, you must not use, disclose or distribute this e-mail without the author's prior permission. We have taken precautions to minimize the risk of transmitting software viruses, but we advise you to carry out your own virus checks on any attachment to this message. We cannot accept liability for any loss or damage caused by software viruses. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/