Re: Oracle's Myth: keep tables and indexes in separate tablespaces

From: Jack <nn_at_mail.com>
Date: Fri, 10 Oct 2003 13:26:16 GMT
Message-ID: <Yryhb.263$3u.180@read3.inet.fi>

Look Howard what You did say at 23 Jun 2002 :  LOL

---

From: "Howard J. Rogers" <dba_at_hjrdba.com> Newsgroups: comp.databases.oracle.server Subject: Re: Basic question on RAID array / Tablespace configuration. Date: Sun, 23 Jun 2002 00:33:46 +1000

There is precisely zero benefit in separating tables from their indexes for performance reasons. Both are segments. Just like Table A and Table B are both segments. Separate A from B by all means, but unless you're consistent, there's no point in separating a table from its index.

Regards
HJR Received on Fri Oct 10 2003 - 08:26:16 CDT