Re: [sqlite] performance impact of index creation order

2017-12-20 Thread Simon Slavin
On 20 Dec 2017, at 3:38pm, Nelson, Erik - 2 wrote: > Assuming that table 'data' is completely constructed, does index creation > order have any performance ramifications? > > For example, would it be reasonable to assume that the order of these two >

[sqlite] performance impact of index creation order

2017-12-20 Thread Nelson, Erik - 2
Assuming that table 'data' is completely constructed, does index creation order have any performance ramifications? For example, would it be reasonable to assume that the order of these two statements has no performance impact? (all fields are integer in this case) create unique index