RE: [U2] Sort / Select keyword
I had not thought of the index, but it does show up in the EXPLAIN data. .X 01 LIST SA SLSMLINELOCCAT.IDX WITH SLSMLINELOCCAT.IDX = [KK] AND WITH CUSTLINELOCCAT.IDX = [LL] EXPLAIN Single-variable predicates processed in index: F0 MATCHES '...'KK'...' AND F0 MATCHES '...'LL'...' Optimizing query block 0 Driver source: SA Access method: select list 0 with 0 ids UniVerse/SQL: Press any key to continue or 'Q' to quit Obviously a PICK flavor UniVerse 10.1.11, AIX 5.3.2 Tom Dodds [EMAIL PROTECTED] 708-234-9608 Office 630-235-2975 Cell -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Laura Hirsh Sent: Friday, October 13, 2006 2:22 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Sort / Select keyword Interesting. I was just thinking that something similar would be useful - especially when using indexes and being able to tell if an index is being used or not. Anyone know of anything similar in Unidata? Thanks, Laura -Original Message- From: Tom Dodds [EMAIL PROTECTED] Sent: Oct 13, 2006 12:40 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Sort / Select keyword This is what I got using EXPLAIN on UV 10.1.11 under AIX 5.3 LIST P/O ORDER CUST P/O-DATE BY CUST WITH CUST 1 EXPLAIN Optimizing query block 0 Tuple restriction: F3 '1' Driver source: P/O Access method: file scan Sorted by: CUST UniVerse/SQL: Press any key to continue or 'Q' to quit --- 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] Sort / Select keyword
John, I think the keyword is EXPLAIN. I don't have a copy of Universe nearby. Thanks, -- Donald Verhagen Application Development Manager [EMAIL PROTECTED] Tandem Staffing Solutions, Inc. 5901 Broken Sound Parkway NW, Suite 450 Boca Raton, FL 33487 USA Voice Phone: 561.226.8261 Fax Phone: 561.226.8115 On 10/13/2006 at 10:02 am, in message [EMAIL PROTECTED], [EMAIL PROTECTED] wrote: I seem to recall that there is a keyword / option / modifier which will display more details about the internals of a select statement. Am I hallucinating again or is there really such an animal ? We are on UniVerse 9.6.1 Cheers John Rodgers --- 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] Sort / Select keyword
Hi John, I seem to recall that there is a keyword / option / modifier which will display more details about the internals of a select statement. SORT blah blah blah EXPLAIN Martin Phillips Ladybridge Systems 17b Coldstream Lane, Hardingstone, Northampton NN4 6DB +44-(0)1604-709200 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Sort / Select keyword
This is what I got using EXPLAIN on UV 10.1.11 under AIX 5.3 LIST P/O ORDER CUST P/O-DATE BY CUST WITH CUST 1 EXPLAIN Optimizing query block 0 Tuple restriction: F3 '1' Driver source: P/O Access method: file scan Sorted by: CUST UniVerse/SQL: Press any key to continue or 'Q' to quit Tom Dodds [EMAIL PROTECTED] 708-234-9608 Office 630-235-2975 Cell -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Don Verhagen Sent: Friday, October 13, 2006 11:43 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Sort / Select keyword John, I think the keyword is EXPLAIN. I don't have a copy of Universe nearby. Thanks, -- Donald Verhagen Application Development Manager [EMAIL PROTECTED] Tandem Staffing Solutions, Inc. 5901 Broken Sound Parkway NW, Suite 450 Boca Raton, FL 33487 USA Voice Phone: 561.226.8261 Fax Phone: 561.226.8115 On 10/13/2006 at 10:02 am, in message [EMAIL PROTECTED], [EMAIL PROTECTED] wrote: I seem to recall that there is a keyword / option / modifier which will display more details about the internals of a select statement. Am I hallucinating again or is there really such an animal ? We are on UniVerse 9.6.1 Cheers John Rodgers --- 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/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Sort / Select keyword
Interesting. I was just thinking that something similar would be useful - especially when using indexes and being able to tell if an index is being used or not. Anyone know of anything similar in Unidata? Thanks, Laura -Original Message- From: Tom Dodds [EMAIL PROTECTED] Sent: Oct 13, 2006 12:40 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Sort / Select keyword This is what I got using EXPLAIN on UV 10.1.11 under AIX 5.3 LIST P/O ORDER CUST P/O-DATE BY CUST WITH CUST 1 EXPLAIN Optimizing query block 0 Tuple restriction: F3 '1' Driver source: P/O Access method: file scan Sorted by: CUST UniVerse/SQL: Press any key to continue or 'Q' to quit --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/