Path: newssvr20.news.prodigy.com!newsmst01.news.prodigy.com!prodigy.com!logbridge.uoregon.edu!newsfeed.berkeley.edu!ucberkeley!newsfeed.pacific.net.au!spool01.syd.optusnet.com.au!spool.optusnet.com.au!not-for-mail Message-Id: <3f86b89f$0$4870$afc38c87@news.optusnet.com.au> From: "Howard J. Rogers" Subject: Re: Oracle's Myth: keep tables and indexes in separate tablespaces Newsgroups: comp.databases.oracle.server Date: Fri, 10 Oct 2003 23:45:55 +1000 References: <8Bdhb.195$hV6.76@read3.inet.fi> <3f857214$0$28118$afc38c87@news.optusnet.com.au> <3Fehb.231$hV6.155@read3.inet.fi> <3f858a85$0$28118$afc38c87@news.optusnet.com.au> Organization: Dizwell Informatics User-Agent: KNode/0.7.2 MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7Bit Lines: 44 NNTP-Posting-Host: 203.164.6.211 X-Trace: 1065793696 4870 203.164.6.211 Xref: newssvr20.news.prodigy.com comp.databases.oracle.server:245006 Jack wrote: > > Look Howard what You did say at 23 Jun 2002 : > LOL > ------------------------------------------------ > From: "Howard J. Rogers" > 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 I'm missing your point Jack. Yes those were my views in 2002. They've been my views for a long, long time. So how does that add weight to your argument that Oracle's official position is the same as mine? Or are you suggesting that when I wrote those words I was doing so as a representative of Oracle? If so, that won't fly. I've never posted here as an official Oracle representative. My views are and have always been mine alone. Regards HJR -- -------------------------------------------- See my brand new website, soon to be full of new articles: www.dizwell.com. Nothing much there yet, but give it time!! --------------------------------------------