What kind of index should I use ?

Поиск
Список
Период
Сортировка
От Gabriel Fernandez
Тема What kind of index should I use ?
Дата
Msg-id 3B050038.4B8340E7@unica.edu
обсуждение исходный текст
Ответы Re: What kind of index should I use ?  (Einar Karttunen <ekarttun@cs.Helsinki.FI>)
Список 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 :-)


В списке pgsql-general по дате отправления:

Предыдущее
От: "Richard Huxton"
Дата:
Сообщение: Re: Various locking questions
Следующее
От: "Aldo Vadillo Batista"
Дата:
Сообщение: phpPgAdmin