At times it is faster to do a complete refresh of an oracle snapshot rather
than an incremental (fast). My question is how do you know when to do the
complete? For example, there are times when a user will run a conversion and
they may update 10% of the rows in the master table. If I do a fast refresh
it may take 4 hours but if I did a complete it takes 2 hours. I have not seen
a pattern in determing the breakeven point. For example, one table we may
update 20% of the rows and the incremental is faster other times we update 5%
of the rows in a different table and the complete would have been an better
option. (Don't quote me on the percentages, just trying to make a point) I
remember seeing a reference to this issue that it was addressed at ioug
conference years ago, but I did not find anything there. So again the
question: What factor(s) should be considered to determine which process(fast
or complete) will provide for a faster refresh for higher than normal updates
to a master table? Thanks
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Tracy Rahmlow
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).