Hello, I have I table like this: CREATE TABLE KeyItem (icon_y int, icon_x int, id INTEGER PRIMARY KEY, pos_x int, pos_y int, size_x int, size_y int, type int, text varchar(15), icon varchar(50), background varchar(50), HomeDevId int, pageNum int);
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); 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? Thanks Kermit Mei _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
