Stefan Đokić | .NET (@thecodeman__) 's Twitter Profile
Stefan Đokić | .NET

@thecodeman__

➡️ Level Up with Everyday .NET Content | Microsoft MVP
➡️ YouTube: youtube.com/@thecodeman_
➡️ TheCodeMan.net Newsletter

ID: 491684234

linkhttps://thecodeman.net calendar_today13-02-2012 22:21:57

2,2K Tweet

6,6K Takipçi

236 Takip Edilen

Stefan Đokić | .NET (@thecodeman__) 's Twitter Profile Photo
Stefan Đokić | .NET
@thecodeman__

4 months ago

Why is your SQL query slow, even with an index on the created_at column? Hint: It’s a common date filtering mistake. So, what's the problem here? Using a function on the column (DATE()) prevents index usage. Instead, you can use a range filter, so the index on created_at is

Why is your SQL query slow, even with an index on the created_at column? Hint: It’s a common date filtering mistake. So, what's the problem here? Using a function on the column (DATE()) prevents index usage. Instead, you can use a range filter, so the index on created_at is