3 ms·
"In the new design a row's primary key directly contributes to its physical key, meaning lookups and iterations on the primary key involve only one scan (rather
by xradionut 14y ago
"In the new design a row's primary key directly contributes to its physical key, meaning lookups and iterations on the primary key involve only one scan (rather than an index scan followed by random lookups in SQLite 3.x/most DBMS)."
Isn't this basically the same concept as a clustered index in MS SQL Server?
- _wmd 14y agoYep, although I'm not sure if clustering is also a hand-triggered process in SQL Server (like it is in e.g. PostgreSQL). In any case SQLite 4.x will do it automatically.
- Shorel 14y agoIn SQL Server that's defined at table creation time. In Oracle it's the same: defined at creation time, but you call it an Indexed Ordered Table (IOT). In MySQL all InnoDB tables are clustered (in that sense) because that's the only storage strategy of InnoDB.