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
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
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
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