Answer the question
In order to leave comments, you need to log in
What is the best index to use on a huge table?
There is a table (3.6 million records) with the following indexes:
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 questionAsk a Question
731 491 924 answers to any question