But then it wouldn't be as much fun. :-) -----Original Message----- From: Clifton Oliver [mailto:[EMAIL PROTECTED] Sent: Saturday, August 11, 2007 1:13 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] [UV] Speeding up a big BY.EXP select
GEEZ people. Why don't you just "ask the computer" rather than debating it? And recognize that the U2 platforms differ depending on the flavor the account is in. Us old timers (33 years in MultiValue) need to remember that everything you think you know is wrong. On Aug 10, 2007, at 8:41 PM, MAJ Programming wrote: > My premise was that > > SSELECT FILE BY @ID BY FIELDNAME SSELECT TEST_FILE BY @ID BY FIELDNAME EXPLAIN Optimizing query block 0 Driver source: TEST_FILE Access method: file scan Sorted by: @[EMAIL PROTECTED] UniVerse/SQL: Press any key to continue or 'Q' to quit > is not the same as > SSELECT FILE BY FIELDNAME. >SSELECT TEST_FILE BY FIELDNAME EXPLAIN Optimizing query block 0 Driver source: TEST_FILE Access method: file scan Sorted by: [EMAIL PROTECTED] UniVerse/SQL: Press any key to continue or 'Q' to quit 0 record(s) selected to SELECT list #0. ------- 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/
