优化索引方法

Explore different methods to optimize indexes, including prefix index optimization, covering index optimization, using auto-increment primary keys, and preventing index invalidation. Learn how prefix indexes can reduce the size of index fields and increase query speed, but also have limitations like inability to be used in order by clauses.