Jared,
I think what you've discovered is just a repeat
of the fact that different functionality is appropriate
in different circumstances.
Imagine replacing your v$sql_workarea_histogram
with a chunky SQL statement that crunched through
a massive table producing a small result set.
In those
PROTECTED]
12/05/2003 01:14 AM
Please respond to ORACLE-L
To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:Re: Expense of 'over ... partition by'
Jared,
I think what you've discovered is just a repeat
of the fact that different functionality
While working on some scripts to monitor PGA usage on 9i, I came across
something interesting while experimenting with different forms of SQL.
I have recently been forcing myself to make use of 'OVER..PARTITION BY' in
SQL so as to be more comfortable in using it. Can't add new tools to the box