If you need to scan large _read only_ table other and other again -- I
would rather say that you have serious DWH design issues. In 2007 we
have enough DWH technologies in Oracle (think materialized views for
exnmple) not to scan that amounts of data every time instead or
thinking how to throw more KIWI at the problem.
On Nov 16, 2007 8:04 AM, Rob Dempsey <Rob.Dempsey_at_5one.co.uk> wrote:
>
>
>
>
> Hi
>
>
>
> Setup
>
>
>
> - Large read only table (100 million rows) in a DW that is required to be
> based mainly in memory for performance reason.
>
--
Alex Fatkulin,
The Pythian Group,
http://www.pythian.com/blogs/author/alexf
--
http://www.freelists.org/webpage/oracle-l
Received on Fri Nov 16 2007 - 10:49:04 CST
