i created an index but the query still slow and here are the schema
CREATE TABLE b11430
-- This table created by SQLite2008 Pro Enterprise Manager
-- Osen Kusnadi - http://www.osenxpsuite.net
-- Created date: 2010-09-24 19:47:33
(
id INTEGER,
nass TEXT,
part INTEGER,
page INTEGER
);
CREATE UNIQUE INDEX idx ON b11430(id);
CREATE TABLE b11430
-- This table created by SQLite2008 Pro Enterprise Manager
-- Osen Kusnadi - http://www.osenxpsuite.net
-- Created date: 2010-09-24 19:47:33
(
id INTEGER,
nass TEXT,
part INTEGER,
page INTEGER
);
CREATE UNIQUE INDEX idx ON b11430(id);
To copy to clipboard, switch view to plain text mode
is there a solution?
Bookmarks