Re: Best practice question: Updating Aggregates

CK wrote:

>Pros: Grouping logic and aggregation is done in SQL, not PL/SQL.

Note that Tom Kyte points out (
http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:6407993912330 among others ) "Never do procedurally that which can be done in a single sql statement."

> "OPTIMIZE LAST"
You really need to read these first:
http://tkyte.blogspot.com/2005/10/next-book-part-ii.html http://tkyte.blogspot.com/2005/09/most-incredible-statement-i-heard-this.html

jg

--
@home.com is bogus.
"I cannot even REMOTELY reproduce this at all." - Tom Kyte