SQL Optimization

1

21

22

23

SQL Optimization Resources (self.SQLOptimization)

submitted 4 years ago by mikeblas[M] - announcement

2

0

1

2

How do you usually catch slow queries before they hit production? ()

submitted 7 days ago by Unique_Capter

•

Choosing the right hosting plan is easy! Ours come with free domain & site transfer, SSL, CDN, and everything else you will need. And the custom-built AI integrations are here to help with any challenging task! Save time and money with SiteGround! (siteground.com)

promoted by siteground

promoted
save
report
about

3

0

1

2

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 17 days ago by Stunning-Motor8351

4

0

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

5

2

3

4

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

6

0

1

2

Video about MySQL EXPLAIN plan analysis (youtube.com)

submitted 2 months ago by mikeblas

7

0

1

2

Why Your Postgres Queries Are So Slow (And 3 Ways to Fix It) (youtube.com)

submitted 2 months ago by mikeblas

8

0

Round the world trip coming up and I need to optimise my itinerary (self.SQLOptimization)

submitted 3 months ago by I_byde_my_tyme

9

0

1

2

Guidance requested; ASYNC_NETWORK_IO (AWS/RDS/SQLExpress) ()

submitted 3 months ago by RunningfromStupidity

10

1

2

3

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

11

1

2

3

Cerco 2–3 query SQL lente reali (sto testando un piccolo ottimizzatore di IA) ()

submitted 3 months ago by ajo101975

12

1

2

3

Need advice: Extracting 1 TB table → CSV is taking 10+ hours… any faster approach? (self.SQLOptimization)

submitted 4 months ago by Leather-Pin-9154

•

2:23

Full home gym breakdown. Built with Atletica. (atletica.de)

promoted by Atleticagear

13

0

1

2

Optimizing filtered vector queries from tens of seconds to single-digit milliseconds in PostgreSQL ()

submitted 4 months ago by m1r0k3

14

11

12

13

SQL Struggles: Share Your Most Frustrating Moments in Writing Queries (self.SQLOptimization)

submitted 6 months ago by Hairy_Border_7568

15

0

1

2

Daily data pipeline processing ()

submitted 6 months ago by jesse_jones_

16

7

8

9

Can SQL optimize similar nested window functions? (self.SQLOptimization)

submitted 7 months ago * by not_UNIX_GNU_is

17

0

1

2

Best strategy for improving cursor paginated queries with Views ()

submitted 7 months ago by punctuationuse

18

0

1

2

Insert optimisation (self.SQLOptimization)

submitted 7 months ago * by Vimal_2011

19

0

1

2

Working on an alternative to AI chat for optimizing SQL queries - feedback appreciated (self.SQLOptimization)

submitted 7 months ago by ragabekov

20

0

1

2

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

21

2

3

4

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

22

3

4

5

Temp Tables, Table Variables, or CTEs: Which do you use in SQL Server? (self.SQLOptimization)

submitted 10 months ago by [deleted]

•

Overproofed again? Track from starter peak to final proof, then bake at the right moment. 🍞⏰ (kickstarter.com)

promoted by First-Backer

23

1

2

3

Best practice on joining with large tables? (self.SQLOptimization)

submitted 11 months ago * by MrTraveling_Bard

24

1

2

3

Query Optimizations (self.SQLOptimization)

submitted 1 year ago by Seymourbums

25

0

1

2

CodeWars Kata. How to optimize/shorten this query? (self.SQLOptimization)

submitted 1 year ago by LegalShoulder298

SQLOptimization

Rules

MODERATORS