8i or 9i for Data Warehouse

From: YTTRI Lisa <lisa.yttri_at_cnh.com>
Date: Tue, 30 Oct 2001 12:15:05 -0800
Message-ID: <F001.003B889C.20011030120520@fatcity.com>

Hi everyone -

I have been asked to do the database planning for a fairly large data warehouse. The warehouse is currently in Sybase and is about 160 GB. They are planning to move to Oracle very soon.

My questions - does it make more sense to spin it up on 8.1.7 or 9? (This will be a pretty good size Solaris machine). Are there newer features in 9i that would really benefit them? I am looking at partitioning tables and using some bit-mapped indexes - something they don't have today. I was originally looking at 8.1.7, but now that 9 has been around for a little bit, I'm wondering if any of you have some advice (good or bad) regarding version 9.

Any and all comments are appreciated.

Thanks -
lisa
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: YTTRI Lisa
  INET: lisa.yttri_at_cnh.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Tue Oct 30 2001 - 14:15:05 CST