Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Which join is the most fast

Status
Not open for further replies.
tonvaneck

tonvaneck

IS-IT--Management
Jan 19, 2004
19
NL
Hello sql users,

Can someone of you tell us wich kind of join the most fasted is?

inner or left/right outer join?

Nice regards,

Ton.
 
Sort by date Sort by votes
The choice between inner and outer join shouldn't be the speed but the records you want to retrieve or not.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

BobThornton
  • Locked
  • Question
Cross Join in an Insert Into
Replies
1
Views
150
carp
carp
Tetol
  • Locked
  • Question
Update script is changing the number of records for the values updated each time I run the query
Replies
1
Views
123
carp
carp
szeiss
  • Locked
  • Question
Need to select the one value if it exists otherwise another value
Replies
4
Views
148
szeiss
szeiss
SashaBuilder3
  • Locked
  • Question
left join with "soft" condition
Replies
2
Views
83
SashaBuilder3
SashaBuilder3
rivi10
  • Locked
  • Question
Join query 1
Replies
3
Views
53
rivi10
rivi10

Part and Inventory Search

Sponsor

Back
Top