What kind of index should I use ?

From: Gabriel Fernandez <gabi(at)unica(dot)edu>
To: PostgreSQL-general <pgsql-general(at)postgreSQL(dot)org>
Subject: What kind of index should I use ?
Date: 2001-05-18 10:58:00
Message-ID: 3B050038.4B8340E7@unica.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Einar Karttunen 2001-05-18 11:16:42 Re: What kind of index should I use ?
Previous Message Aldo Vadillo Batista 2001-05-18 10:14:05 phpPgAdmin