Kermit Mei wrote: > The mostly useful SQL sentence is (MyDevId is known by user): > > SELECT * FROM KeyItem WHERE HomeDevId=MyDevId order by pageNum; > > Now, the items of this table may be more than 100,000 lines. If I use > the following Index, can it improve the previous query's speed? > > CREATE INDEX index_KeyItem_HP ON KeyItem(HomeDevId, pageNum ASC);
Yes, this should help. > I use index firstly, so I don't know how to manipulate it? Just > create a index like this, or any more operation is needed? No, just creating the index should be enough. SQLite should use it automatically if it's beneficial for a particular query. Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
