Re: how to speed query

On Fri, 14 Sep 2001 T(dot)R(dot)Missner(at)Level3(dot)com wrote:

> Here is a slimmed down example of my table
>
> table sipmsg(
>
> time long,
> callid varchar(256)
>
> )
>
> the query simply asks for all callids between 2 times.
> I have an index on the time column but it doesn't get used.
> Is there a better way for me to be doing this?
> Seems so simple.
>
> more info:
> the table now has over 200k rows or which the average query will return a
> couple of hundred rows.
> running on solaris 8 at 433mhz ( i think ) with 1 gig of memory

Did you made a vacuum analyze?
Do you have a index defined for that column?
Eventually a 'set enable_seqscan = off;' will help you.

Best regards
Herbie
--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Herbert Liechti http://www.thinx.ch
ThinX networked business services Adlergasse 5, CH-4500 Solothurn
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~