Thread: What kind of index should I use ?

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 :-)

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