News for hackers. Stuff that matters.
Re:SQLite's Automatic Indexes by Shorel on Wednesday December 28, 2022 @03:00PM (#34165167)
Clustered indexes in MSSQL Server, Index Organized Tables in Oracle, and any table in MySQL using InnoDB as storage engine.
Re:SQLite's Automatic Indexes by SigmundA on Wednesday December 28, 2022 @03:06PM (#34165249)
InnoDB is similar to SQLite all tables are clustered indexes, if you don't have suitable primary key it creates a hidden one similar to rowid in SQLite.

MSSQL and Oracle give you a choice for table storage to either have unordered heaps or ordered b-trees, depending on whether a clustered index is defined.

PG only has unordered heaps, indexes are always secondary data structures. PG could really use true clustered indexes as an option.