Is an index needed for a primary key in SQLite?

Question

When an integer column is marked as a primary key in an SQLite table, should an index be explicitly created for it as well? SQLite does not appear to automatically create an index for a primary key column, but perhaps it indexes it anyway, given its purpose? (I will be searching on that column all the time).

Would the situation be any different for a string primary key?

Answer 1

it does it for you.

http://www.sqlite.org/lang_createtable.html

it there in the middle.