[sqlite] Adding index to table makes SELECT much slower. Why?

Hi- I am new to sqlite, and am having a puzzling problem. I have read that adding an INDEX to a sqlite table can never make a SELECT statement slower. However, in my case, it seems to be making the select statement an order of magnitude slower, which is not what I wanted! What could be going

Re: [sqlite] Adding index to table makes SELECT much slower. Why?

ll subset of the data (450Mb) which exhibits the same behaviour. The data is public (it is from the National Ocean Database), and so if anyone wants to see it I would be happy to put it on my web server. Cheers, and thanks to everyone who helped me! Jamie Pringle On Wed, Oct 8, 2008 at 6:50

Re: [sqlite] Adding index to table makes SELECT much slower. Why?

/OC5/WOA05/pr_woa05.html , and should be acknowledged in the event you use it for any oceanographic research. Cheers, Jamie On Thu, Oct 9, 2008 at 12:16 PM, James Pringle <[EMAIL PROTECTED]> wrote: > Hi all- > >Thanks for your many suggestions. I have tried many of your >