No Featured Found!
What are Mysql Indexes
A database index is a structure that improves the speed of retrieval of data from our table. Index is similar to the index of a book. If you want to find a chapter you look in the index first without scanning the whole page. Users cannot see th...
How to delete an INDEX in a table in MySQL?
We can drop INDEX from table by using DROP INDEX statement, it is used to delete an index form a table. Syntax: ALTER TABLE table_name DROP INDEX index_name; Example: Suppose you have created an INDEX named "person_user_name_idx" on th...
The index is used to search the data in a table. The index is basically a data structure that search our data. It is applied usually on a column of a table. It is usually a B-tree but can also be hash table and other depending upon the ...