Hi everyone...
This should be a fairly simple question to answer. I have a "user" table, with three columns that i always query seperately (i.e. user id, user email, and username). The user id is the designated as a primary key, the username and email are designated as unique. so my question is, to optimize my queries, is there a need to create an actual seperate index designated "index", for id, username, and email seperatly even though they are already marked as unique and primary. I know it's a simple question. I think i already know the answer, i just need some one to verify it for me before i move on.
I think that the unique and primary indexes, work the same as the "index" type, just that the mysql application makes sure that you are not entering a duplicate value of something that already exists in a column that uses unique and primary types.
Please let me know what you guys/gals think.
Pz!
