RE: UDT SELECT optimization

2004-02-04 Thread Chuck Mongiovi
was hoping that this way of thinking naturally made it's way into u2 .. -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Dennis BartlettSent: Wednesday, February 04, 2004 8:46 AMTo: 'U2 Users Discussion List'Subject: RE: UDT SELECT optimization I've

Re: UDT SELECT optimization

2004-02-04 Thread Mark Johnson
put the WITH's first if that matters. - Original Message - From: Dennis Bartlett To: 'U2 Users Discussion List' Sent: Wednesday, February 04, 2004 8:45 AM Subject: RE: UDT SELECT optimization I've always thought that a SELECT that reduces the results fi

UDT SELECT optimization

2004-02-02 Thread Chuck Mongiovi
Title: RE: [UD]LOGTO Does anyone know whether one of these two statements is faster? SELECT FILE BY SOME.DATE WITH SOME.FIELD = "XXX" -or- SELECT FILE WITH SOME.FIELD = "XXX" BY SOME.DATE Does the parser / optimizer (if there is one) do the filter portion of the statement first

Re: UDT SELECT optimization

2004-02-02 Thread Mark Johnson
d. my 1 cent. - Original Message - From: Brian Leach To: 'U2 Users Discussion List' Sent: Monday, February 02, 2004 11:24 AM Subject: RE: UDT SELECT optimization Chuck, The order should be immaterial ( it is on every other database I can think of ). Jus