What index to put on the field to speed up work?

M

McMike2018-11-06 06:36:56

PostgreSQL

McMike, 2018-11-06 06:36:56

There is a field with a hash, sometimes a search is performed on it. What type of index should be hung on this field to speed up work, and is it necessary at all? Isn't just a uniqueness index enough?

Reply

Answer the question

In order to leave comments, you need to log in

0 answer(s)

Similar questions

S

syskoff2014-02-06 15:23:10

How to setup xlog rewriting in postgresql 8.4? 0Reply

A

Andrey2018-09-15 18:59:51

How to organize daily copying of data from PostgreSQL to SQL Server? 1Reply

D

Danil Samodurov2021-11-26 14:24:38

Which SQL query will display the most frequently occurring records? 4Reply

A

Anton Misyagin2021-11-26 18:44:37

How to shut down the docker stack correctly? 2Reply

D

des1roer2016-04-21 07:45:45

Postgres insert coalesce? 1Reply

Didn't find what you were looking for?

Ask your question