Hi, I have another question about indexes in Sqlite.
Does the declaration of an INTEGER PRIMARY KEY implies the creation of an index ? I am asking because I have noticed a performance boost when I create an index on an INTEGER PRIMARY KEY when sorting rows with the primary key column. More generally, does declaring any column primary key implies that this column will be indexed ? I am not sure about that because when I do a PRAGMA index_list(), there is no index shown for the primary key. Thanks for any hints, Bertrand Mansion Mamasam --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]