N
N
nikolau2018-05-10 12:55:38
MySQL
nikolau, 2018-05-10 12:55:38

Do I need to add index if there is already unique?

Do I need to add an index index to speed up the selection, if the field already has a unique index (unique)?

Answer the question

In order to leave comments, you need to log in

1 answer(s)
D
Dmitry Dart, 2018-05-10
@nikolau

No, it doesn `t need.
Only if you need a composite index for 2 fields, then you will make a new index for this field + another.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question