title: SQLite Index Before Appending Rows
body: <p>If I create an index on some columns in an SQLite table then append rows to the table after that, do I have to delete and recreate the index or will the index update automatically? What if I delete rows?</p>