Category Archives: mysql

MySQL – Show Indexes Table of content A MySQL Index is a type of special lookup table that is used to make data retrieval easier in a database. It points to the actual data in the database. MySQL allows various types of indexes to be created on one or more columns in a table. They […]

MySQL – Clustered Index Indexes in MySQL are used to retrieve the data much faster from the database. We (users) cannot see the indexes, but they work behind to speed up searches and queries. They are categorized into two types: clustered and non-clustered indexes. A clustered index can sort the data in a table manually. […]

MySQL – Non-Clustered Index Table of content Indexes in MySQL are used to retrieve the data much faster from the database tables or views. Users cannot see the indexes on the application level, but they work behind to speed up searches and queries. There are two types of Indexes in MySQL − Clustered Index Non-Clustered […]