Indexes in MySQL is one of the more useful features. Indexes in MySQL help to search particular record(s) from the database faster. In short, indexes make the SELECT queries speedy. Although, indexes have considerable advantages but these have some disadvantages too, for which the developer has to pay in shape of disc space and slow insert, update query processes. MySQL Indexes types are Primary Key, Unique, Index, and Fulltext.
Indexes play such an important role in database development that it’s worth devoting some additional time to learn these features. Here the Indexes category, introduces you to these important concepts and general database indexing terminology. View the following questions to learn more about indexes.
Indexes Related Categories
Primary Key Indexes | Unique Key or Index | Normal Indexes or Keys | Full Text Indexes
Indexes Related FAQs
|