High db file sequential reads during imp?
Date: Fri, 9 May 2008 08:22:11 +0100
Relative newcomer to performance analysis. I was surprised, upon investigating a very slow import job, to find very high 'db file sequential read's. This activity was mostly associated with an index that was being updated while around 11 million rows were inserted to a normal heap table. I'm clearly missing something obvious here but why would imp be reading (and not writing?) so heavily from this index?