4 ms·
> innodb uses the primary key as a clustering index, or the first UNIQUE index if there's no PK. In MSSQL, the primary key or the even a "Clustered index" is u
by cogman10 5y ago
> innodb uses the primary key as a clustering index, or the first UNIQUE index if there's no PK.
In MSSQL, the primary key or the even a "Clustered index" is ultimately the ordering of a table. If a neither are provided then MSSQL uses an invisible row id column. If the clustered index is not made with the "UNIQUE" constraint, MSSQL will also create the row id column.
That is to say, yes, this article is very MySQL oriented.
- tomnipotent 5y ago> is ultimately the ordering of a table Clustered index leaf nodes contain the actual row data of the table itself, which is why there can only be one.