[sqlite] suggestion for an optimized sql

[Clodo]

Hi, i have a table like this with thousand of records:

CREATE TABLE Table01 (
 id       integer,
 value01  text,
 value02  text
);

I need to optimize the following sql:

SELECT * FROM Table01 WHERE VALUE01<VALUE02.

How i can use indexes to avoid a full-table scan? Thanks!


-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------