hi my question is : if i create table that contains primary key like; create table TEST (field1 varchar not null primary key);
do i need to create index on it or not? and is it better to create table with a primary key and then import data in it or create table without a key , import data and then just create index on the table. (which is faster- or should i ask which is the fastest way to import data in the table?) then if i create proper table , is it advisable to order data by column with primary key on it or data with index on it thank you -- View this message in context: http://www.nabble.com/is-primary-key-already-indexed---tp22596778p22596778.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
