Re: Slow query performance on large table

On Tue, Mar 04, 2003 at 02:45:18PM -0000, Paul McKay wrote:
>
> Select time,value
>
> >From measurement
>
> Where assessment = ?
>
> And time between ? and ?
>

Please run this with EXPLAIN ANALYSE with values that slow the query
down.  By bet is that you have an index which needs wider statistics
setting on the column to be useful, but without the output from
EXAPLIN ANALYSE it'll be hard to tell.

A

--
----
Andrew Sullivan                         204-4141 Yonge Street
Liberty RMS                           Toronto, Ontario Canada
<andrew@libertyrms.info>                              M2P 2A8
                                         +1 416 646 3304 x110