Be specific in your answer

Table building principles

Column type selection

Index principle

hash index

Common misunderstandings about index building

Index classic topics

Index experiment

Clustered index and non-clustered index

Page split test

Index coverage

A classic topic on a forum

ideal index

Pseudo hash index

Principles of multi-column indexes

Indexing and sorting

Duplicate and redundant indexes

repair table

Query general principles

explain detailed explanation

in type subquery trap

Force the use of indexes

count and union

limit page turning optimization topic