-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Harish Vishwanath wrote: > I would like to understand when sqlite generates an autoindex on primary keys > of tables.
An autoindex is created when a column is unique since that is the only way to know if a value being inserted is a duplicate of an existing one. One does not need be created if the primary key is an integer since the existing rowid can be used. See http://www.sqlite.org/lang_createtable.html#rowid Roger -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.9 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iEYEARECAAYFAktrzuoACgkQmOOfHg372QTyfwCgg+jir+ncdod0HdAgDgP0H0Sa Mh4AmwYEIns0xQwo8yy43F6erVcBXBwO =gAud -----END PGP SIGNATURE----- _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users