Обсуждение: multiple key indices vs single key

Поиск
Список
Период
Сортировка

multiple key indices vs single key

От
admin
Дата:
When using a btree index, the manual says I can specify up to 7 keys in a
single multi-column index. Is there any difference between calling a
single index with 7 keys and calling 7 indices with 1 key each, btree in
both cases? In which instances should a btree index use only a single key?
Where could I have found this information in the online manual (read
chapter 7. Indices and Keys of the User's Guide).

Thanks again,
Marc