Re: disk i/o balancing

From: Bob Johnson <no-email_at_links.into.here>
Date: 1997/02/06
Message-ID: <01bc13fc$ecfcad40$b92e64a1@azkrdw00173.krd.az.bp.com>#1/1

G'day

I've only had BAD experiences when using raid subsystems with Oracle, mainly things like reduced performance and lack of being able to control exactly where tablespaces / tables go.

When you have parent / child tables, rather than split them into different tablespaces, why not cluster them, ie store them together, this makes joining the tables much more efficient at the cost of increased time for table scans.

Bob Johnson Received on Thu Feb 06 1997 - 00:00:00 CST