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: [email protected] 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 > [email protected] > To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
