[sqlite] INDEX + SELECT or just SELECT?

[Alberto Simões]

Hi

I have a big table (16 million records) and I want to perform JUST
ONCE an operation to sort by one column:

 SELECT * FROM tbl ORDER BY i DESC;

Now, is it faster to perform just the select, or to do:

 CREATE INDEX tmp ON tbl (i);
 SELECT * FROM tbl ORDER BY i DESC;

Thank you
Alberto

--
Alberto Simões

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