Re: index and queries using '<' '>'

At 16:23 18/11/2004 +0100, Martijn van Oosterhout wrote:
> The system seems to think that a scan is cheap because the table is so
> small.
The table currently contains just over 10000 elements. So 238 rows is a
small part of it.

> Have you ever ANALYZEd that table?
Yes. That and reindex (in case of a problem).
I have also tried ALTER TABLE ALTER COLUMN SET STATISTICS, but without
improvement.

> Also, EXPLAIN ANALYZE gives a much better idea of what is going on...
You mean ANALYZE VERBOSE ?


Since the table is still growing, and the amount of rows in the reply of
the query is quite uniform (it's not dependant on the size of the table), I
hope that the statistics will evolve in a state that will force the use of
the index.


thanks

--
Marc