Tag: mysql indexes
The Best pratice for Drop Duplicate indexes on MySQL DB
Problem statement: Very often, it needs to create indexes on DB. on the positive side, these indexes speed up SELECT queries (sometimes UPDATE &...
MySQL Indexes basics and MySQL Indexes types
Types of Indexes in MySQL
MySQL supports the following indexes
B+ Tree indexes
Hash indexes
Full-Text index
R Tree indexes
B+ Tree Indexes
Highly Useful(>90%) in many real-time use-cases
Work for Equality...
