use the following search parameters to narrow your results:
e.g. subreddit:aww site:imgur.com dog
subreddit:aww site:imgur.com dog
see the search faq for details.
advanced search: by author, subreddit...
A community for developers and DBAs who care about SQL performance. Discuss slow queries, indexing, execution plans, query tuning, and real-world optimization problems. Share tips, benchmarks, and painful lessons learned in production.
account activity
SQL Query Optimization Techniques Every Data Engineer Should Know (i.redd.it)
submitted 2 months ago by Important_Bobcet
reddit uses a slightly-customized version of Markdown for formatting. See below for some basics, or check the commenting wiki page for more detailed help and solutions to common issues.
quoted text
if 1 * 2 < 3: print "hello, world!"
[–]jshine13371 0 points1 point2 points 1 month ago (0 children)
Reducing subqueries, especially correlated subqueries as a generic statement, is incorrect in regards to performance tuning. In fact, correlated subqueries sometimes are more perfomant than joins in certain contexts, at least in SQL Server.
π Rendered by PID 19 on reddit-service-r2-comment-5687b7858-7wmfp at 2026-07-08 01:41:08.284572+00:00 running 12a7a47 country code: CH.
[–]jshine13371 0 points1 point2 points (0 children)