the records in nonclustered indexes contain the primary key columns ... InnoDB uses this primary key value to search for the row in the clustered index. If the primary key is long, the secondary indexes use more space, so it is advantageous to have a short primary key.
the records in nonclustered indexes contain the primary key columns ... InnoDB uses this primary key value to search for the row in the clustered index. If the primary key is long, the secondary indexes use more space, so it is advantageous to have a short primary key.
このブックマークにはスターがありません。
最初のスターをつけてみよう!
MySQL :: MySQL 8.4 Reference Manual :: 17.6.2.1 Clustered and Secondary Indexes
1 人がブックマーク・1 件のコメント
\ コメントが サクサク読める アプリです /