Title: What are the benefits and disadvantages of an index? Post by: Chinnab on Jan 31, 2018 What are the benefits and disadvantages of an index?
Title: What are the benefits and disadvantages of an index? Post by: mizunoshiro on Jan 31, 2018 An index can help speed up row retrieval if less than ten percent of the table is included in the query results. However, when data changes are made, such as adding or deleting rows, the index must be updated which can slow down DML operations.
|