For improving the speed of operation in a table we use MySQL INDEX. We can create more than one field as a index field in a table. This is basically use for searching process so that it can lookup records very fast.
As it fetches record very fast from the database, during insert and update it takes a lots of time because database needs to insert or update index value as well.
CREATE UNIQUE INDEX index_name ON tbl ( column1, column2,…);
Here unique index means that two rows cannot have the same index value.
For using simple index that has the duplicity simply remove the UNIQUE keyword from the query.
You can also create INDEX for ascending or descending order i.e.
CREATE UNIQUE INDEX index_name ON tbl ( column1 DESC, column2 ASC,…);
Altering INDEX after creating a table:
ALTER TABLE tbl ADD INDEX (column1);
ALTER TABLE tbl DROP INDEX (column1);
To check whether table has INDEX or not:
SHOW INDEX FROM tbl;
Read Also: Optimize a MySQL database
MySQL uses indexes for below operations:
For any types of queries, you can contact us on info[at]namasteui.com.
Hormonal balance plays a pivotal role in overall well-being, influencing various aspects of health, from…
Dog walking is an excellent way to maintain your furry friend's camaraderie and provides many…
Introduction Businesses understand the diverse requirements of mobile applications, which provide a competitive advantage. There…
The Internet of Things (IoT) has recently changed the world. It links gadgets together and…
NFTs, or Non-Fungible Tokens, are revolutionizing the digital economy. These unique digital assets, authenticated through…
It is safe to say that if you are in need of a good laptop…