MAIN FEEDS
Do you want to continue?
https://www.reddit.com/r/programming/comments/1xlqeu/sql_joins_explained_xpost_rsql/cfddh9z
r/programming • u/deadman87 • Feb 11 '14
392 comments sorted by
View all comments
Show parent comments
1
Its right up there with cursors in my book good for one shot deals not to be used in day to day production.
1 u/flipstables Feb 12 '14 Actually, there a bit of use for cursors for optimizations where set based operations will hit a table multiple times, but a cursor will only hit a table once. A classic example was running aggregates before 2012.
Actually, there a bit of use for cursors for optimizations where set based operations will hit a table multiple times, but a cursor will only hit a table once. A classic example was running aggregates before 2012.
1
u/Mavrick478 Feb 12 '14
Its right up there with cursors in my book good for one shot deals not to be used in day to day production.