How does index fragmentation affect performance?

Index fragmentation occurs when data is inserted, updated, or deleted, causing the index

structure to become inefficient. This can negatively impact performance in several ways: