"We learn something new everyday!" As a tribute to this saying...
We have this large million of records table. An audit table exists to record every single update or deletion of a row in this table. We were thinking of creating an index on this audit table where no indexes existed before. However, every update/deletion would require an update of this new index, therefore, slowing the performance of write operations on this table.
Lesson of the Day: Indexes, although improves the performance of read operations, leads to more overheard if this table is often updated.
I know i'm dumb..
- ▼ March (4)