Hello, My understanding is that an index is automatically created on any column that is used in the primary key (or a composite index is created if the key is composed of different columns). If this is correct then why don't I see indexes for those in my table (I'm using SQLite Administrator and Firefox plugin based SQLite manager). I do see indexes for the columns that I added a unique constraint upon.
Is the above just a GUI error in these tools or an index need to be created separately on the columns used in primary keys? Thanks, Hitesh _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users