Advertisement

06.29.2006 at 01:00PM PDT, ID: 21904024
[x]
Attachment Details

Alternate for Left Outer Join

Asked by sval1411 in Databases Miscellaneous

Tags: join, left, outer

Hi, I am working on a Stored Proc which is using 5 tables. One of the tables is using an Outer Join with the other table. The perfomrance is very bad due to outer join. It is very slow. Could anyone give me a suggestion for an alternate way. And I am pulling 5,6 columns from the table(one that  does not have matching values) which is using an Outer Join.

Thought probably an inline select would work, but I guess that is only if we are pulling one column(not sure about this)
Thanks in advance.
Start Free Trial
[+][-]06.29.2006 at 01:02PM PDT, ID: 17012978

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zone: Databases Miscellaneous
Tags: join, left, outer
Sign Up Now!
Solution Provided By: angelIII
Participating Experts: 4
Solution Grade: B
 
 
[+][-]06.29.2006 at 01:05PM PDT, ID: 17013016

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]06.29.2006 at 03:43PM PDT, ID: 17014249

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]06.29.2006 at 10:35PM PDT, ID: 17015699

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]06.30.2006 at 05:18AM PDT, ID: 17017205

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32