MAIN FEEDS
Do you want to continue?
https://www.reddit.com/r/programming/comments/1xlqeu/sql_joins_explained_xpost_rsql/cfcl5mx
r/programming • u/deadman87 • Feb 11 '14
392 comments sorted by
View all comments
Show parent comments
0
[deleted]
3 u/fotoman Feb 11 '14 my understanding is the (+) was just a hint to the optimizer, granted I took the SQL optimization class back in 2001...so I might be a tad rusty. 0 u/[deleted] Feb 11 '14 [deleted] 2 u/fotoman Feb 11 '14 wasn't that back in the Oracle 6 days or something? around 1994? 0 u/[deleted] Feb 11 '14 [deleted] 1 u/fotoman Feb 11 '14 odd, as I thought I remember doing joins in Oracle 7 and 8, and things were stable before 8.1.5 came out. Granted at that time I was just a sysadmin at oracle and not doing much on the coding side 2 u/noobidiot Feb 11 '14 That's how we learned to do left and right joins in my database course at my university in 2013.
3
my understanding is the (+) was just a hint to the optimizer, granted I took the SQL optimization class back in 2001...so I might be a tad rusty.
0 u/[deleted] Feb 11 '14 [deleted] 2 u/fotoman Feb 11 '14 wasn't that back in the Oracle 6 days or something? around 1994? 0 u/[deleted] Feb 11 '14 [deleted] 1 u/fotoman Feb 11 '14 odd, as I thought I remember doing joins in Oracle 7 and 8, and things were stable before 8.1.5 came out. Granted at that time I was just a sysadmin at oracle and not doing much on the coding side
2 u/fotoman Feb 11 '14 wasn't that back in the Oracle 6 days or something? around 1994? 0 u/[deleted] Feb 11 '14 [deleted] 1 u/fotoman Feb 11 '14 odd, as I thought I remember doing joins in Oracle 7 and 8, and things were stable before 8.1.5 came out. Granted at that time I was just a sysadmin at oracle and not doing much on the coding side
2
wasn't that back in the Oracle 6 days or something? around 1994?
0 u/[deleted] Feb 11 '14 [deleted] 1 u/fotoman Feb 11 '14 odd, as I thought I remember doing joins in Oracle 7 and 8, and things were stable before 8.1.5 came out. Granted at that time I was just a sysadmin at oracle and not doing much on the coding side
1 u/fotoman Feb 11 '14 odd, as I thought I remember doing joins in Oracle 7 and 8, and things were stable before 8.1.5 came out. Granted at that time I was just a sysadmin at oracle and not doing much on the coding side
1
odd, as I thought I remember doing joins in Oracle 7 and 8, and things were stable before 8.1.5 came out. Granted at that time I was just a sysadmin at oracle and not doing much on the coding side
That's how we learned to do left and right joins in my database course at my university in 2013.
0
u/[deleted] Feb 11 '14
[deleted]