#fulltablescan

PrecisionSQLPrecisionSQL
2026-01-14

Index On NULL Column Does NOTHING?!

Your performance just DIED! Created an index but queries with NULL are still slow? Indexes IGNORE NULL values! Full table scan on millions of rows! Your index is USELESS! Watch the disaster!

youtube.com/watch?v=PUJ8KouC1V0

Client Info

Server: https://mastodon.social
Version: 2025.07
Repository: https://github.com/cyevgeniy/lmst