Hello All I'm relatively new to sqlite and database stuff and I have a question concerning indices in sqlite:
If I create an index for a table to speed up searches, etc. and then do writing operation on that table (including removals and changes of lines), will I have to remove and recreate the index manually or will the recreation of the index be handled automatically by sqlite? I couldn't find this information in the sqlite documentation. Regards JM _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users