Timeline for Are the index here will suffice to make the query faster?
Current License: CC BY-SA 3.0
4 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jan 11, 2017 at 15:36 | comment | added | BeginnerDBA | SQL Server and MySQL form a vast majority of database platforms out there - therefore, quite typical :P | |
| Jan 11, 2017 at 11:04 | comment | added | ypercubeᵀᴹ | "In a typical RDBMS, unless you change the default, a PK is going to yield a clustered index" Not really, unless "typical" means "SQL Server or MySQL". And the question is specifically about MySQL, so I wonder why you need to comment about "typical DBMS" | |
| Jan 11, 2017 at 4:57 | comment | added | Rick James |
InnoDB really needs a PRIMARY KEY. In MySQL, a PK is, by definition, clustered and UNIQUE.
|
|
| Jan 11, 2017 at 4:43 | history | answered | BeginnerDBA | CC BY-SA 3.0 |