Author Archives: user

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 – Unique Index Table of content MySQL Indexes are used to return the data from the database real quick. The users cannot see the indexes performing, instead they are just used to speed up the queries. However a unique index, in addition to speeding up data retrieval queries, is also used to maintain data […]

MySQL – Drop Index Table of content The DROP statement in MySQL database is used to remove or delete an existing database object such as a table, index, view, or procedure. Whenever we use DROP statement with any of the database objects, like indexes, it will remove them permanently along with their associated data. Therefore, […]