News for hackers. Stuff that matters.
Re:How does a B-tree make queries fast? by scotty79 on Sunday December 24, 2023 @12:34PM (#38755042)
> If all you do are full table scans (possibly feeding to hash-joins), you won't benefit from indexes at all!

In most cases it means that you shouldn't be doing what youa re trying to do. Or best case, that maybe database is not the right tool for your job.

Re:How does a B-tree make queries fast? by SpicyLemonZest on Sunday December 24, 2023 @12:50PM (#38755148)
True, but it's still relevant in the early stages of iterating on a project. I'm familiar with one team that started investing in database-level optimization months before even beginning to deprecate their `loadAllRowsFromTheLargestTable` RPC.