Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Which method is more efficient
dunno about that. I was making the assumption that *which* columns
changed was already known.
This would require testing by someone familiar with the data.
Jared
"Jamadagni, Rajendra" <Rajendra.Jamadagni_at_espn.com>
Sent by: root_at_fatcity.com
05/29/2003 10:24 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> cc: Subject: RE: Which method is more efficient
Jared,
Agreed, but what about the resources needs to find _which_ column changed
?? Would that offset the extra redo generated? Heck, I'd just generate the
update statements based on two tables to _only_ update the changed
columns. It is pretty easy, if both tables have _same_ columns ...
Raj
-----Original Message-----
Sent: Wednesday, May 28, 2003 6:15 PM
To: Multiple recipients of list ORACLE-L
There are easier ways to test redo generation than mucking about with
logminer.
Update only the column that changes and check redo generation:
15:06:09 rsysdevdb.radisys.com - jkstill_at_dv01 SQL> @t1
[ much stuff deleted ]
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author:
INET: Jared.Still_at_radisys.com
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services ---------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (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).