sqlite-users  

[sqlite] Question about Auto Idexes generated by SQLite

Harish Vishwanath
Thu, 04 Feb 2010 22:14:21 -0800

Hello,

I am using SQLite with Python (via SQLAlchemy). I would like to understand
when sqlite generates an autoindex on primary keys of tables. I am seeing
inconsistent behaviour in my case, where sqlite is automatically generating
indexes for some tables on their primary keys, but not all tables in the
schema.

I am referring to indexes named as sqlite_autoindex_*. Appreciate your help!

Regards,
Harish
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users