|
|
Posted by David Portas on 11/28/91 11:56
kalaivanan wrote:
> hi dis is kalaivanan,
> which one of inner join or left join is efficient and in what way.
Inner joins and outer joins achieve different results so in general it
won't make sense to compare them on performance.
In cases where an inner and outer join are guaranteed to give the same
result I suggest you test it out for yourself. Performance is too
heavily dependent on other factors for there to a be a single, simple
answer.
--
David Portas, SQL Server MVP
Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.
SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
--
Navigation:
[Reply to this message]
|