I used the following syntax to create index "CREATE UNIQUE INDEX persons_1x ON persons (pid,hid);"
Gaurav On Thu, Nov 24, 2011 at 1:54 AM, Petite Abeille <[email protected]>wrote: > > On Nov 24, 2011, at 8:48 AM, Simon Slavin wrote: > > > Is the table indexed on that column ? > > And if it is... what's its selectivity? > > What 's the query plan? > > > _______________________________________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- Gaurav Vyas Graduate Research Assistant, Transportation Engineering University of Texas at Austin _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
