Re: Non-Relating Join Criteria
Hi Fred,
My question is whether or not there can be a strong
reason to prefer one over the other, such as impact
on the order of evaluation.
No. Order of evaluation can and will be shuffled by the optimizer if
that can improve performance.
The only reason for using one and not the other is readability of the
query.
Note, though, that for OUTER JOINs, the two queries are NOT
equivalent!
--
Hugo Kornelis, SQL Server MVP
My SQL Server blog:
http://sqlblog.com/blogs/hugo_kornelis
.
Relevant Pages
- Re: Cannot upgrade SQL Server 2005 Reporting Services from Standard to Enterprise
... You did not show us the command you used for command prompt installation, however did you try something like the following? ... Are you sure your SQL Server Instance isn't an Evaluation Edition? ... Server that is running SQL Server 2005 Reporting Services, ...
(microsoft.public.sqlserver.setup) - Re: SQL Server 120 Trial
... the Evaluation Edition of SQL Server cannot be ... upgraded with security fixes or service packs. ... There is usually no support provided for evaluation software, ... >can't afford to upgrade just yet, but I am also unable to ...
(microsoft.public.sqlserver.security) - Re: Update string too long?
... > And we won't question to reason for this routine as you asked... ... Pro SQL Server 2000 Database Design - ... > support the full length of the inserted data? ...
(microsoft.public.sqlserver.programming) - Re: SQL Server 120 Trial
... evaluation software you ... >> I can appreciate that Microsoft doesn't want to support ... the Evaluation Edition of SQL Server ... >>>A) Block UDP port 1434 inbound and outbound traffic at ...
(microsoft.public.sqlserver.security) - RE: Identity/Seed Values
... is not a substitute for this. ... SQL Server doesn't change the IDENTITY value ... IDENTITY yourself except by deleting and then inserting a row (another reason ... why you shouldn't tie external meaning to an arbitrary IDENTITY value). ...
(microsoft.public.sqlserver.programming) |
|
