On Wed, 1 Mar 2017 17:00:16 +0000
Deon Brewis <de...@outlook.com> wrote:
> If not, is there a way to efficiently implement a UNIQUE constraint
> in a different way? (Trigger maybe?)
I'll defer to others about how SQLite will respond, but I'd be tempted
to do this:
create table Foo(UniqueCol primary key, ExtraCol, ... );
create index i_cover_foo on Foo(UniqueCol, ExtraCol);
I expect how useful/expensive that is would depend on cardinality.
--jkl
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
