S
S
Samir Kurbanov2019-08-30 11:36:15
Database design
Samir Kurbanov, 2019-08-30 11:36:15

What is the best index to use on a huge table?

There is a table (3.6 million records) with the following indexes:
5d68db77a7b3a033140279.png
Each row of this picture is an index and into the fields of the table included in it.
As you can see in the picture, most of them are composite and some fields (for example [komanda]) are used in several composite indexes , which, as I heard, is not rational.
It is required to optimize the speed of sampling from this table. Moreover, queries are executed using all fields, which is in the picture above:
- select queries using only one field
- select queries using several fields
With such selections, is it better to make separate indexes for each field or composite?

Answer the question

In order to leave comments, you need to log in

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question