Hello Rachmat, by creating one and using a fitting where- or order-by - clause. See http://www.sqlite.org/lang_createindex.html
perhaps you would like to ask you question with a litte bit morte detail? Martin Rachmat Febfauza schrieb: > how to make sqlite use index? > > > > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users