Path: newssvr20.news.prodigy.com!newsmst01.news.prodigy.com!prodigy.com!prodigy.com!rip!news.webusenet.com!peer01.cox.net!cox.net!newshosting.com!news-xfer2.atl.newshosting.com!newsfeed.icl.net!newsfeed.fjserv.net!skynet.be!skynet.be!newsfeed2.funet.fi!newsfeeds.funet.fi!nntp.inet.fi!central.inet.fi!inet.fi!read3.inet.fi.POSTED!53ab2750!not-for-mail From: "Jack" Newsgroups: comp.databases.oracle.server 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> Subject: Re: Oracle's Myth: keep tables and indexes in separate tablespaces Lines: 21 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2800.1158 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 Message-ID: Date: Fri, 10 Oct 2003 13:26:16 GMT NNTP-Posting-Host: 194.252.147.254 X-Complaints-To: abuse@inet.fi X-Trace: read3.inet.fi 1065792376 194.252.147.254 (Fri, 10 Oct 2003 16:26:16 EEST) NNTP-Posting-Date: Fri, 10 Oct 2003 16:26:16 EEST Organization: Sonera corp Internet services Xref: newssvr20.news.prodigy.com comp.databases.oracle.server:245002 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