Re: Oracle 7.3 as a Data Warehouse

In article <63a46p$sis_at_camel21.mindspring.com>, Tony <trodgers_at_mindspring.com> wrote:
>I'm curious if anyone out there is using Oracle 7.3 running as a data
>warehouse. I'm specifically looking for a warehouse that is 40 - 50GB or
>larger. I'm curious about the experiences people have had with very large
>tables and how the CBO handles access, as well as general read times. Any
>input would be valuable. I'd just like to compare notes.

Tony,

I hate to sound cute but it depends on the exact release of Oracle and the platform and release of OS. Some general guide lines though

For large tables (fact tables typically in star/snowflake) try using Partitioned views on the time dimension.

Test everything at full size (some bugs only appear at larger sizes)

The front end tool will but but constraints on how things are to be done use it during the testing.

Hope this helps

Mark Received on Sat Nov 01 1997 - 00:00:00 CST