Simon Slavin <slav...@bigfraud.org> wrote: > Need someone more familiar with the design philosophy and source code than I > am (which is not at all). > > <http://www.sqlite.org/foreignkeys.html#fk_indexes> > > Says you need an index for anything which acts as a parent. I can understand > why under normal circumstances (large table) this > would be desirable. But is there anything which would /require/ it ?
It's not the index that's necessary, but the UNIQUE constraint. It just so incidentally happens that SQLite uses indexes to enforce such a constraint. -- Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users