Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Tuning index tablespaces

Re: Tuning index tablespaces

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Thu, 19 Jan 2006 19:38:01 +0100
Message-ID: <b0nvs1t6accuamd6mqs0qkgdnmk870bsov@4ax.com>


On 19 Jan 2006 05:15:38 -0800, "Tarby777" <nick_williamson_at_mentorg.com> wrote:

>However, I
>would still maintain that process A (hammering indexes) and process B
>(hammering data) will experience lower contention if the data and the
>indexes are separated.

Is that an observation you can substantiate by benchmarks, or just an opinion?
The main reason for separating data and indexes is maintenance.

--
Sybrand Bakker, Senior Oracle DBA
Received on Thu Jan 19 2006 - 12:38:01 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US