Re:How does a B-tree make queries fast?
by blowski on Sunday December 24, 2023 @08:28AM
(#38753324)
I can write to one database, replicate it (for example, by log shipping), and add an index only on the replica. This is not just being pedantic, this is a real-world pattern for some analytics solutions. You have a very high number of writes, and then build a reporting database at the end of every day, with all reads going to that database.
[ Parent
| on HN ]
Re:How does a B-tree make queries fast?
by scotty79 on Sunday December 24, 2023 @12:34PM
(#38755045)
That is a very valid scenario. But when you do those things you already know costs and benefits of the indexes so you are not going to be harmed by "no indexes = database slow" heuristc.
"database = fast" is way worse heuristic to believe in for the people that need heuristics to move on with what they are doing.