Sample Header Ad - 728x90

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