Hello, Would adding an unique index on an integer primary key be of any benefit? Or is it redundant?
In "Primary key and index", Ben Carlyle wrote the following: 1 Table = 1 BTree, the BTree holds the data and is ordered by ROWID 1 Table with 1 Index = 2 BTrees, the second referring to rows in the first 1 Table with PRIMARY KEY = 1 Table with 1 (unique) Index 1 Table with INTEGER PRIMARY KEY = 1 Table, with its own BTree forming its unique index -- Ben Carlyle, "Primary key and index", 2004 http://osdir.com/ml/db.sqlite.general/2004-02/msg00067.html Is that an accurate description? Thanks in advance. Kind regards, -- PA. http://alt.textdrive.com/nanoki/ _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
