Re: concepts document part about separating indexes and tablspaces
From: David Aldridge <david_at_david-aldridge.com>
Date: Thu, 15 May 2008 13:32:24 -0700 (PDT)
Message-ID: <178310.35076.qm@web805.biz.mail.mud.yahoo.com>
Date: Thu, 15 May 2008 13:32:24 -0700 (PDT)
Message-ID: <178310.35076.qm@web805.biz.mail.mud.yahoo.com>
It's actually in the DBA Guide, and it's still there now: http://download.oracle.com/docs/cd/B19306_01/server.102/b14231/indexes.htm#i1006372
"Using different tablespaces (on different disks) for a table and its index produces better performance than storing the table and index in the same tablespace. Disk contention is reduced."
- Original Message ---- From: David Sharples <davidsharples_at_gmail.com> To: ricks12345_at_gmail.com Cc: oracle-l_at_freelists.org Sent: Thursday, May 15, 2008 3:18:48 PM Subject: Re: concepts document part about separating indexes and tablspaces
because it doesn't
2008/5/15 Rick Ricky <ricks12345_at_gmail.com>:
i was talking to someone about this today. I cannot remember where in the Concepts document that it says that separating data from indexes improves performances?
-- http://www.freelists.org/webpage/oracle-lReceived on Thu May 15 2008 - 15:32:24 CDT