On Apr 26, 3:28 am, "Paul Lautman" <paul.laut...@btinternet.com>
wrote:
> Logos wrote:
> > While I know that in a regular query a JOIN is more expensive than a
> > nested query,
>
> What you "know" is in fact wrong. It it almost ALWAYS the other way round.

I seem to be reading a fair number of articles which seem to
contradict each other on this...blah. Back in the day (wow, 10yrs
ago!) I recall being taught that joins were more expensive than
subqueries. Things seem to be more confusing now :P

Perhaps to sum things up more succintly for my question: Are the
queries comprising views handled any differently than a normal query?

Tyler