Re: Copying a SUM Value
Quote
The act of copying to all rows may seem useless to you ...
"
Useless" never crossed my mind.
"
Inefficient" and "
Slow" did, though.
This will work just
fine for a table with a few rows, but try it with a real table of
millions of rows. Your Application's performance will go through the floor.
Updating rows is [relatively] slow. It
always involves writes to disk, if only to the Transaction [binary] log and that's Orders of Magnitude slower than reading stuff.
But, as I said, YMMV.
Regards, Phill W.
Subject
Written By
Posted
February 27, 2023 02:29PM
February 27, 2023 03:23PM
February 27, 2023 03:53PM
February 27, 2023 04:06PM
February 27, 2023 06:00PM
February 27, 2023 07:12PM
February 28, 2023 05:44AM
February 28, 2023 10:08AM
Re: Copying a SUM Value
March 01, 2023 09:23AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.