News for hackers. Stuff that matters.
Re:Database Fundamentals by tonymet on Friday December 15, 2023 @06:31PM (#38660190)
If you are using oracle, mysql , mssql you are typically using b-tree index. mysql supports hash index but i rarely see it applied in prod (probably just habits or lack of familiarity).
Re:Database Fundamentals by roetlich on Friday December 15, 2023 @09:06PM (#38661104)
Yes, but a lot of the cool, new DBs use LSM trees. The post we're currently discussing also spends more time explaining LSM trees + WAL, than it does B-trees.

But your point is still valid. :)