[font="Verdana"]
calvo (6/8/2010)
Ensuring your tables are properly indexed and using inner joins where possible would help performance.
Yes, i appreciate it, but please let exclude proper indexing (including Clustered) or assume that indexes are fully compliant with both approaches, no problem/over head w.r.t indexes.
And sub-query by default Returns a NULL same as that of Left Outer Join scenario where matching rows do not exist.
I'm pretty sure it's very dependant on the structure of the tables and the format of the query also. Maybe more information would be helpful. Can you post the query?
I wish to, but it is not possible to put even code segment as i stated earlier that the query is so complicated/confusing that it would not make any sense to your people time.
Please, let try to be focus on generic questions stated in start of thread, so we can all benefit from it.
Thank you.
[/font]