Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Tablespaces and indexes
Hi Michiel
On Thu, 20 Sep 2001 13:32:35 +0200, "Michiel Brunt" <mbrunt_at_inergy.nl>
wrote:
>However, I have heard others say it is better to store indexes in a seperate
>index tablespace.
The basic idea in tablespace layouts is to reduce the "contention" (ie waiting) of the disks as the heads move back and forth. Many operating systems can also do simultaneous reads from from different disks.
If your tablespaces are NOT located on disks that are striped then it is better to have indexes in their own tablespace and on a different physical disk. If the disks are striped together into a logical volume it is less important to separate the data and indexes since you really don't know which physical disk is being hit anyways. In that case, if one is trying to get the ultimate in disk efficiency one would put the index tablespace on a different stripe set and make sure each stripe set uses a different group of disks.
Regards
Dale