Re: [Maria-discuss] 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?