Re: [sqlite] integer primary key and unique index?

Petite Abeille wrote: > > Would adding an unique index on an integer primary key be of any > benefit? Or is it redundant? > It would not help, and would in fact slow down all inserts, deletes, and updates for no benefit. It is redundant. HTH Dennis Cote

[sqlite] integer primary key and unique index?

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