News for hackers. Stuff that matters.
Re:OrioleDB – solving some PostgreSQL wicked problems by SigmundA on Friday February 25, 2022 @12:04PM (#30469419)
It is such a common access pattern that many database engines always have a clustered index (MySql - InnoDB, Sqlite) whether you use them directly or not.

I like having a choice as there is in Sql Server or Oracle, but for many use cases its a waste to write to a heap and to an index (which is just a hidden IOT) then look up in the index and dereference to the heap both in space and time.

There are no comments on this comment yet.