Sql Outer Join Slow Query

when thinking of using an Outer Join on a select query in T-SQL, you should always think about performance issue it comes with.

- Make sure you include a statement in a Where Clause to kinda limit the data set returned since the SQL query executes a While, Clouse, first.