1-1 Be specific in your answer

1-2 Table building principles

1-3 Column type selection

1-4 Index principle

1-5 hash index

1-6 Common misunderstandings about index building

1-7 Index classic topics

1-8 Index experiment

1-9 Clustered index and non-clustered index

1-10 Page split test

1-11 Index coverage

1-12 A classic topic on a forum

1-13 ideal index

1-14 Pseudo hash index

1-15 Principles of multi-column indexes

1-16 Indexing and sorting

1-17 Duplicate and redundant indexes

1-18 repair table

1-19 Query general principles

1-20 explain detailed explanation

1-21 in type subquery trap

1-22 Force the use of indexes

1-23 count and union

1-24 limit page turning optimization topic