On Fri, 18 May 2001, Gabriel Fernandez wrote:
> Hi,
>
> I have a table with a lot of fields and I would want to obtain a quicker
> query response.
>
> The main characteristics are:
>
> The table is NOT often updated, I mean INSERT and UPDATE are sporadic
> sentences, but SELECT sentences are often executed.
>
> The most used query is something like
>
> select distinct field1 from my_table where field1 is not null and field2
> like '...'
>
> Should I use a BTREE index or would be better to use a HASH or RTREE ?
>
> Thanks,
>
> Gabi :-)
>
Use always a btree. The other algorithms are not implemented as well as
btree.
- Einar