Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Tuning index tablespaces
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 DBAReceived on Thu Jan 19 2006 - 12:38:01 CST