[U2] Order of criteria

Hi All, Does the order of criteria matter in a select or list statement, or is the execution order arbitrary? For example, if I wanted to select vendors who sell apples in Denver, is Select vendors with location='Denver' and products='Apples' the same as Select vendors with

RE: [U2] Order of criteria

: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Aherne, John Sent: Thursday, February 24, 2005 1:52 PM To: u2-users@listserver.u2ug.org Subject: [U2] Order of criteria Hi All, Does the order of criteria matter in a select or list statement, or is the execution order arbitrary

RE: [U2] Order of criteria

- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Aherne, John Sent: Thursday, February 24, 2005 12:52 PM To: u2-users@listserver.u2ug.org Subject: [U2] Order of criteria Hi All, Does the order of criteria matter in a select or list statement, or is the execution order arbitrary

RE: [U2] Order of criteria

I agree with Kevin's answer. Also, it may depend on which U2 product/pick-like product you are using. I always try to order the WITH statements so the one selecting the fewest records is first. However, I always place the fields with translates last since I know that translates are much more

Re: [U2] Order of criteria

PROTECTED] On Behalf Of Aherne, John Sent: Thursday, February 24, 2005 1:52 PM To: u2-users@listserver.u2ug.org Subject: [U2] Order of criteria Hi All, Does the order of criteria matter in a select or list statement, or is the execution order arbitrary? For example, if I wanted to select vendors

RE: [U2] Order of criteria

EXPLAIN is Universe-only, not Unidata. Sorry about that. It goes anywhere on the RetrieVe command line. If run from tcl, output is to the screen. -Original Message- From: Don Verhagen Charles, What is the syntax for the EXPLAIN keyword I don't see it documented in Unidata (6.X) I