On Nov 24, 2011, at 8:56 AM, Gaurav Vyas wrote: > I used the following syntax to create index > "CREATE UNIQUE INDEX persons_1x > ON persons (pid,hid);"
Check you query plan (i.e. explain query plan [1]). I doubt such index has any use as SQLite doesn't support "index skip scans" access plan or such [2]. Check the friendly manual for what's supported: The SQLite Query Planner 1.1 Index term usage examples http://www.sqlite.org/optoverview.html [1] http://www.sqlite.org/lang_explain.html [2] http://docs.oracle.com/cd/B19306_01/server.102/b14211/optimops.htm#i51571 _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users