On Sun, 23 May 2010, David Jarvis wrote:
> The measurement table indexes (on date and weather station) were not being
> used because the only given date ranges (e.g., 1900 - 2009) were causing the
> planner to do a full table scan, which is correct.
I wonder if you might see some benefit from CLUSTERing the tables on the
index.
Matthew
--
And the lexer will say "Oh look, there's a null string. Oooh, there's
another. And another.", and will fall over spectacularly when it realises
there are actually rather a lot.
- Computer Science Lecturer (edited)