I would like to know the difference between character type and integer type when configuring MySQL clustered index.
If you look at the principles of clustered index, it’s a sequential configuration.
If I configure PK with strings and add data, is it correct that insertion occurs in the middle of the index and this causes index page segmentation, resulting in poor performance?
If you’re familiar with clustered indexes, please explain.