Question: are primary keys automatically indexed?
Answer: Yes, primary key is automatically indexed in MySQL because primary key, index, etc gets stored into B-trees. ... In the above table, Id is implicitly indexed.