SQLite Forum

Understanding memory allocation behavior of SQLite
Login
You will also note that the default behaviour of `CREATE INDEX` is to build the index by in-order insertion.  That is why the process

```
create table
insert data
create indexes
```

is quicker than

```
create table
create indexes
insert data
```