Re: [sqlite] Create Index after Data Populated

2018-05-31 Thread Simon Slavin
On 31 May 2018, at 8:59pm, Andrew Stewart wrote: >I have a database that is populated with data (and more being > added) and I have realized that I need an extra index to speed up access. > How long should it take to update the Index. There are about 1billion rows > in the

[sqlite] Create Index after Data Populated

2018-05-31 Thread Andrew Stewart
Hi, I have a database that is populated with data (and more being added) and I have realized that I need an extra index to speed up access. How long should it take to update the Index. There are about 1billion rows in the database Thanks, Andrew Stewart Software Designer