Use indexes to reduce the overhead on MySQL server

Use indexes to reduce the overhead on the MySQL server

In the MySQL database, indexes are used to optimize the database server by reducing the cost for searching data. Take it as an example of the index page you see at the end of textbooks. It contains the page number of important words, so you do not have to check each page of the book to find that word. You just get the page number from the index page and directly lands on that specific page.

Web URL:

[SREEDHAR-NIRVANA]

Very Good Explanation, where and how and why to use Index

[mujib]

i have two columns id and customer no while i apply index on both column it's still not effective and shows total rows after indexing.

[ashifrisalct]

Can I apply this if I selecting * from table