Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

query related to inner join V/S all entries........

Former Member

‎07-13-2006 2:18 PM

0 Kudos

Hi all,

I have a dought ...related to join and all entries

Which one will be the better as per performance prospective :

1>For all entries

or

2> using inner join condition

i am combining 2 tables ...

but in my where clause is having 6-7 condition if i used inner join concept...

Please let me know thanks for the help...in advance

regards

Amit

2 REPLIES 2

Former Member

‎07-13-2006 2:21 PM

0 Kudos

Depends on the case.

Regards, Felipe Cunha

Former Member

‎07-13-2006 3:19 PM

0 Kudos

Check I wrote a program that compares the performance of a join against for all entries. The join won. But the best thing to do is for you test and compare both methods for your particular situation.

In a select, the most important factor is the use of an index.

Rob