Monday, March 31, 2008

Lesson of the Day

"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..

No comments: