What are advantage and disadvantage of indexing in MySql

Advantage

1-Index use for query results is much better performance.

2-It is used for quickly retrive data.

3-It can be used for sorting.

4-Unquie index gurantee uniquely identify records in the database.

5-Full text search used for optimize searching.

Disadvantage

1-They decrease performance on inserts,updates and deletes.

2-They take up memory space.