maria-discuss team mailing list archive
-
maria-discuss team
-
Mailing list archive
-
Message #02716
Re: doubt about index
-
To:
maria-discuss@xxxxxxxxxxxxxxxxxxx
-
From:
Reindl Harald <h.reindl@xxxxxxxxxxxxx>
-
Date:
Tue, 23 Jun 2015 00:47:48 +0200
-
In-reply-to:
<CAH3kUhHOvWTtr1HwJTLsu1Mw9+J4A-dx6kOLq8QV4=VRdJWkeA@mail.gmail.com>
-
Openpgp:
id=13540402D67A7F71C6E974EA866063CF7F780279; url=https://arrakis.thelounge.net/gpg/h.reindl_thelounge.net.pub.txt
-
Organization:
the lounge interactive design
-
User-agent:
Mozilla/5.0 (X11; Linux x86_64; rv:38.0) Gecko/20100101 Thunderbird/38.0.1
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
References
