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 da

[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 ARGU