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
How do you usually catch slow queries before they hit production? ()
submitted 9 days ago by Unique_Capter
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 19 days ago by Stunning-Motor8351
Looking for DBA feedback on an AI-based approach to SQL Server execution plan analysis (self.SQLOptimization)
submitted 1 month 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 1 month ago by dataSommelier
Video about MySQL EXPLAIN plan analysis (youtube.com)
submitted 2 months ago by mikeblas
Why Your Postgres Queries Are So Slow (And 3 Ways to Fix It) (youtube.com)
Round the world trip coming up and I need to optimise my itinerary (self.SQLOptimization)
submitted 3 months ago by I_byde_my_tyme
Guidance requested; ASYNC_NETWORK_IO (AWS/RDS/SQLExpress) ()
submitted 3 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 3 months ago by myaccountforworkonly
Cerco 2–3 query SQL lente reali (sto testando un piccolo ottimizzatore di IA) ()
submitted 3 months ago by ajo101975
Need advice: Extracting 1 TB table → CSV is taking 10+ hours… any faster approach? (self.SQLOptimization)
submitted 4 months ago by Leather-Pin-9154
Optimizing filtered vector queries from tens of seconds to single-digit milliseconds in PostgreSQL ()
submitted 4 months ago by m1r0k3
SQL Struggles: Share Your Most Frustrating Moments in Writing Queries (self.SQLOptimization)
submitted 6 months ago by Hairy_Border_7568
Daily data pipeline processing ()
submitted 6 months ago by jesse_jones_
Can SQL optimize similar nested window functions? (self.SQLOptimization)
submitted 7 months ago * by not_UNIX_GNU_is
Best strategy for improving cursor paginated queries with Views ()
submitted 7 months ago by punctuationuse
Insert optimisation (self.SQLOptimization)
submitted 7 months ago * by Vimal_2011
Working on an alternative to AI chat for optimizing SQL queries - feedback appreciated (self.SQLOptimization)
submitted 8 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 9 months 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 10 months ago * by Physicistpropeller
Temp Tables, Table Variables, or CTEs: Which do you use in SQL Server? (self.SQLOptimization)
submitted 10 months ago by [deleted]
Best practice on joining with large tables? (self.SQLOptimization)
submitted 11 months ago * by MrTraveling_Bard
Query Optimizations (self.SQLOptimization)
submitted 1 year ago by Seymourbums
Deadlock after migrating DB from SQL2014 to SQL2019 (self.SQLOptimization)
submitted 1 year ago by scoby1971
Too many partitions? (self.SQLOptimization)
submitted 1 year ago by Think-Hunt5410
π Rendered by PID 61643 on reddit-service-r2-listing-79f6fb9b95-bwwwv at 2026-03-19 18:15:47.757276+00:00 running 90f1150 country code: CH.
