What happens if I insert a row in the middle of an sqlite table `WITHOUT ROWID`?
0
votes
1
answer
46
views
WITHOUT ROWID
is an sqlite optimization. Doc states, it is making the primary key of the table to a clustered index.
As far I know, clustered index means that the physical ordering of the rows will follow the index, making linear scans effective on it.
However, what will happen if I insert a row into the middle of such a table? Will it be really needed to shift the whole table file after that?
Asked by peterh
(2137 rep)
May 4, 2025, 08:14 AM
Last activity: May 4, 2025, 02:15 PM
Last activity: May 4, 2025, 02:15 PM