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

N

Nordman992020-04-24 20:29:02

What is the difference between the original Postgresql build and the 1C Postgresql build? 1Reply

K

kaato2015-10-16 17:42:18

Which database to choose for a small service? 4Reply

P

Pantene7422018-02-20 22:51:08

What is the best way to use Node.js + Postgre in practice? 1Reply

N

niko832011-09-02 19:19:28

Find differences between 2 base dumps (under 1 GB)? 3Reply

I

Ilnar252018-02-27 12:18:05

How to write uniqueness in database on rails? 1Reply

Didn't find what you were looking for?

Ask your question