Re: Oracle 8.0.3 - solid enough for a *production* datawarehouse?

Steve:

We are migrating to Oracle8.04 as well, so I don't know any "in practice" facts yet. Theoretically, Oracle8 can be tuned/configured to handle those very large tables much better. Check out the following:

1. Partitioned tables
2. Partitioned indexes

Again theoretically, Oracle8's optimizer is *smart* enough to do partition elimination. In other words, it should be smart enough to determine that only a single partition of a table or index (say, 1 million rows) needs to be scanned rather than the whole 100 millions rows.

Hope this helps,
Dave

Steve Phelan wrote in message
<887272590.11294.0.nnrp-04.c2de712e_at_news.demon.co.uk>...
>Hi,
>
>I've just migrated a medium size datawarehouse across to Oracle 8.0.3 on
>IBM's AIX 4.1.5. All *seems* OK. However, some folks at one of our sister
>sites is of the opinion that Oracle 8 is not yet 'solid' enough for
>production datawarehouses...
>
>Anyone out their with some real experience of using Oracle 8 in a
>datawarehouse of over 100 million rows? What do you think of Oracle 8. What
>are the pros/cons? Any bugs which you have found? Given the choice, would
>you stay with Oracle 7.3? Etc., etc.
>
>Many thanks for any info. you can supply.
>
>Steve Phelan.
>
>
>
Received on Sun Feb 15 1998 - 00:00:00 CST