Provides various official and user-released code examples. For code reference, you are welcome to learn about the "MySQL" index Type normal, unique, full text.
Question 1: What are the differences between mysql index types normal, unique, and full text?
Normal: indicates a normal index.
Unique: unique, and duplicate indexes are not allowed. If the field information is not repeated, for example, when the ID card number is used as an index, you can set it to unique.
Full textl: full-text search index. When FULLTEXT is used to search for a long article, it works best. It is used in short text. If there are only one or two lines of text, the normal INDEX is also acceptable.
In summary, the index category is determined by the content characteristics of the index field. Normally, normal is the most common.
Question 2: Which fields in the table should be selected as indexes during actual operations?
To make indexes more efficient, you must consider which fields to create indexes and what types of indexes to create when creating indexes. There are seven principles:
1. Select a unique index
2. Create an index for fields that often require sorting, grouping, and Union operations
3. Create an index for fields that are often used as query Conditions
4. Limit the number of Indexes
5. Try to use indexes with a small amount of data
6. Try to use the prefix for indexing.
7. Delete indexes that are no longer in use or rarely used
AD: truly free, domain name + VM + enterprise mailbox = 0 RMB
