On 7/13/07, Buchanan, Jason <oracle_at_digistar.com> wrote:
>
>
> Depends on the report, depends on the company, etc. I've worked in
> shops where the requirements of some reports didn't need
> transactionally-consistent data and "WITH UR" was perfectly
> satisfactory (DM/DW/VLDB). Doing the same type of report in Oracle
> certainly would have required many gigabytes of undo.
>
>
Inaccurate results are acceptable to avoid sacrificing some runtime and
undo?
--
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
--
http://www.freelists.org/webpage/oracle-l
Received on Thu Jul 26 2007 - 10:10:40 CDT
