Pragma automatic_index command not executing correctly in SQLite

Question

I have used Pragma automatic_index=true command in SQLite so that default indexing on tables is stopped. But when I execute select statement on table without this statement, it don't do indexing of records on same. So whats the use of this command if output with it and without it is same?

Answer 1

Hi Monika,


Pragma automatic_index command is by deafult true in Sqlite.

so when you  used Pragma automatic_index=true, its mean indexing will be continue


to stop default indexing use 

sqlite> Pragma automatic_index=false.