Have a datamart (star scema) about 4M rows in the fact. Performance sucked, so I broke it into 8 tables and partioned viewed. they SUCK! I turned the ora.init parameter on. I constraied each table on the first part of the prim key. (time). I created a union all view. Oracle 7.3 HP 1 GB ram and 2 processors I then ran a query and - no matter the where clause it will hit every table. Even if I say where time_key = 3. No matter what. If the elimination of tables dosen't work then the benefits of severly minimined. True this will allow me to scan the table quicker (8x). But i need more! I'm running redbrick on the same box - ported the datamart over in 2 hours. Redbrick kicks the crap out of oracle. Maybe oracle is not ready for warehousing! - I'm going to oracle 8 soon any body know if oracle 8 is any better. I'm about to put oracle back in the box and burn it. I appreciate comments from anyone who has had partion view work to eliminate tables! or actually built a 'REAL' datamart in oracle and had oracles star execution path kick in w/o hints and had it return a result set in a reasonable time frame (< 15 secs). Thanks for any comments / knowledge! Dave. [log in to unmask] -------------------==== Posted via Deja News ====----------------------- http://www.dejanews.com/ Search, Read, Post to Usenet