Регистрация
andrey440
06.02.2021 20:08
Химия
Есть ответ 👍

ТЕСТОВЫЕ ЗАДАНИЯ ПО ХИМИИ. НУЖНО ВСЕ БАЛЛЫ ОТДАЮ :(

238
379
Посмотреть ответы 1

Ответы на вопрос:

nas81
nas81
4,7(76 оценок)

In MySQL a PRIMARY or UNIQUE KEY creates an index on the columns defined in the constraint. If there are multiple columns a composite index is created.

If its an InnoDB table the PRIMARY KEY also becomes the clustered index for the table.

It doesn't make sense to add additional indexes with the same definitions as a PRIMARY/UNIQUE.

For other RDBMS an index will be required for these constraints. Even if you are allowed to create a constraint without an appropriate index, it will be required to get any reasonable performance.

Популярно: Химия