title: Is an index needed for a primary key in SQLite?
body: <p>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).</p>
  
  <p>Would the situation be any different for a string primary key?</p>