Created summary table data intially deferred refresh deferred that
contains a 3 table join with cardinality of the join about 4.5 million
rows. If I do not have an index on the summary table, and do a refresh
the amount of transaction logging is reasonable. But when an index is
added and a refresh is tried. The logging seems to increase
exponentially (not double or triple but even more) to the point I have
to kill the refresh cause it's about to fill up our log file system.
The only way I see around this is to drop the index, refresh, recreate
the index. Does anybody know why the logging increases so much when
there is an index added to a summary table?