Loading

Pragma automatic_index command not executing correctly in SQLite

Monika Arora

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?

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Aarti15y ago
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.
0