Re: Best practice question: Updating Aggregates

casey.kirkpatrick_at_gmail.com wrote:
> Dan,
>
> I find your response a bit disconcerting - do you actually encourage
> students to evaluate final solutions based on "which one goes fastest",
> in lieu of evaluation of flexibility, maintainability, and data
> integrity (the issues I actually asked about in my post)?

Of course not in the more advanced material. But for a beginner SET TIMING ON and AUTOTRACE are about as sophisticated as you want to get.

> Believe me, I do care about performance. But my cumulative 15 years of
> collegiate and work experience has reinforced one mantra that never
> fails: "OPTIMIZE LAST".

How LAST? ;-)

> Please don't make your students learn this the hard way. And, by the
> way, do you see any strong points with the options I outlined above
> with respect to best coding practice?
>
> Regards,
>
> CK

The advice given was, I think, appropriate for a beginner. Starting the discussion with StatsPack, AWR Reports, Active Session History, TKPROF, and v$ objects would just overwhelm.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)