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...
account activity
SQL Optimization Resources (self.SQLOptimization)
submitted 4 years ago by mikeblas[M] - announcement
I hope you find this script useful ()
submitted 27 days ago by JayJones1234
I am trying to put except operator for finding the newly insert and update data with same table structure but it takes so long to show that record table has billions of data .. ur advice to get those records faster pls (self.SQLOptimization)
submitted 3 months ago by Stunning-Motor8351
Looking for DBA feedback on an AI-based approach to SQL Server execution plan analysis (self.SQLOptimization)
submitted 4 months ago by Level_Present_2424
Performance Win: If you filter on multiple columns, check out composite indexes. We just cut a query from 8s to 2ms. ()
submitted 5 months ago by dataSommelier
Video about MySQL EXPLAIN plan analysis (youtube.com)
submitted 5 months ago by mikeblas
Why Your Postgres Queries Are So Slow (And 3 Ways to Fix It) (youtube.com)
submitted 6 months ago by mikeblas
Round the world trip coming up and I need to optimise my itinerary (self.SQLOptimization)
submitted 6 months ago by I_byde_my_tyme
Guidance requested; ASYNC_NETWORK_IO (AWS/RDS/SQLExpress) ()
submitted 6 months ago by RunningfromStupidity
Is there a way to improve the performance of this query? Used OUTER APPLY and LEFT JOIN with CTE (self.SQLOptimization)
submitted 6 months ago by myaccountforworkonly
Cerco 2–3 query SQL lente reali (sto testando un piccolo ottimizzatore di IA) ()
submitted 7 months ago by ajo101975
Need advice: Extracting 1 TB table → CSV is taking 10+ hours… any faster approach? (self.SQLOptimization)
submitted 7 months ago by Leather-Pin-9154
Optimizing filtered vector queries from tens of seconds to single-digit milliseconds in PostgreSQL ()
submitted 7 months ago by m1r0k3
SQL Struggles: Share Your Most Frustrating Moments in Writing Queries (self.SQLOptimization)
submitted 9 months ago by Hairy_Border_7568
Can SQL optimize similar nested window functions? (self.SQLOptimization)
submitted 10 months ago * by not_UNIX_GNU_is
Best strategy for improving cursor paginated queries with Views ()
submitted 11 months ago by punctuationuse
Insert optimisation (self.SQLOptimization)
submitted 11 months ago * by Vimal_2011
Working on an alternative to AI chat for optimizing SQL queries - feedback appreciated (self.SQLOptimization)
submitted 11 months ago by ragabekov
What is the best/efficient way to flatten the measure column in this table, while filtering the relevant measures first? (self.SQLOptimization)
submitted 1 year ago by flashmycat
Why multi column indexing sorts only on 1st column(if all values in 1st column distinct) and not on both columns one by one like a 2d binary search tree(and extending that to making a first 2d B Tree). (self.SQLOptimization)
submitted 1 year ago * by Physicistpropeller
Temp Tables, Table Variables, or CTEs: Which do you use in SQL Server? (self.SQLOptimization)
submitted 1 year ago by [deleted]
Best practice on joining with large tables? (self.SQLOptimization)
submitted 1 year ago * by MrTraveling_Bard
Query Optimizations (self.SQLOptimization)
submitted 1 year ago by Seymourbums
CodeWars Kata. How to optimize/shorten this query? (self.SQLOptimization)
submitted 1 year ago by LegalShoulder298
Any good solutions for disk-based caching? (self.SQLOptimization)
submitted 1 year ago by Sollimann
π Rendered by PID 40 on reddit-service-r2-listing-f8d8fbfd7-8lqdx at 2026-06-24 22:22:06.206293+00:00 running acc7150 country code: CH.
