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.
1-They decrease performance on inserts,updates and deletes.
2-They take up memory space.