SQLite Forum

integer primary key and index table
Login
The document says 'integer primary key ' is an alias for the rowid.so if a column set 'integer primary key',does sqlite create a index table to mapping this column and rowid columm? 

select * from table1 where col = 123; if col is integer primary key,does this select statement do a binary search in index-table for rowid first´╝îthen use the rowid to do binary search for row data in table1?