← Back to team overview

maria-discuss team mailing list archive

Re: doubt about index


Am 23.06.2015 um 00:43 schrieb Roberto Spadim:
hi guys, i`m with a doubt...
when i have a primary key i know that's a unique key
when i have a index with primary key + any other column, does mariadb
consider that it's unique too?

if it is defined as unique key yes

what is "index with primary key + any other column"?
you have two keys in that case and the select uses one of them

i`m thinking more about SELECT optimization

how does it matter if a key is unique or not for select optimization?

Attachment: signature.asc
Description: OpenPGP digital signature

Follow ups