Forum

Share:

Notifications

Clear all

Normal join or left outer join which give more performance?

Last Post

RSS

<img alt='' src='//www.gravatar.com/avatar/145acdc57a7ca44c99fa14d88bdddeb8?s=80&r=g&d=mm' srcset='//www.gravatar.com/avatar/145acdc57a7ca44c99fa14d88bdddeb8?s=80&r=g&d=mm 2x' class='avatar avatar-80 photo' height='80' width='80' decoding='async'/>

Posts: 36

VK

Guest

Topic starter

Aug 01, 2020 8:11 am

(@VK)

Eminent Member

Joined: 3 years ago

Which joins are faster?

Topic Tags

fasterjoins normaljoinsorouterjoins

1 Reply

<img alt='' src='//www.gravatar.com/avatar/38776ecf23daaf8d2b881408fc55fc47?s=80&r=g&d=mm' srcset='//www.gravatar.com/avatar/38776ecf23daaf8d2b881408fc55fc47?s=80&r=g&d=mm 2x' class='avatar avatar-80 photo' height='80' width='80' decoding='async'/>

Posts: 47

Info User

Guest

Aug 01, 2020 8:14 am

(@Info User)

Eminent Member

Joined: 3 years ago

As far as I know Normal join will give you the better performance becase it simply filter the rows based on the join condition equal or inner.

Wheras outer joins follow the concept called matching and non matching rows it has to look for both, thats why it is less faster than other joins.

Hope it helps.

Reply

Leave a reply

Share:

Forum Statistics

10 Forums

174 Topics

321 Posts

0 Online

1,386 Members

Latest Post: Query Optimization: A Comprehensive Guide for Stored Procedures Our newest member: anjalirrb Recent Posts Unread Posts Tags

Forum Icons: Forum contains no unread posts Forum contains unread posts

Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

Powered by wpForo version 2.2.2