> So technically, with the expressive join syntax, you don't need a WHERE
> clause anymore?
Well, with SQL you always had some freedom in choosing the right way
to do something since you usually have more than one way to construct
a query that returns the same result set. I'd say that until ANSI join is
fully fixed in 9i you shouldn't rely on it and always test if you get expected
results. Besides, WHERE clause makes your query a bit more readable as
it may not be all too obvious that your column=constant in join condition
is simply a filter on one table and not really a join condition for two tables...
As of performance - test it, there's no better way to tell if some query will
perform better than some equivalent query on your particular system with
your particular data.
--
Vladimir Zakharychev (bob@dpsp-yes.com) http://www.dpsp-yes.com
Dynamic PSP(tm) - the first true RAD toolkit for Oracle-based internet applications.
All opinions are mine and do not necessarily go in line with those of my employer.
Received on Thu Sep 19 2002 - 00:56:41 CDT
