The rule is more like don't put a table and index on the same spindle.
There is a difference. If you have a multi-platter drive that is logically
divided into multiple file systems then nothing is really gained by putting
a table in a datafile on one file system and the indexes in a datafile on
another file system on the same physical drive. What you really need is two
seperate physical drives.
Nemniss wrote:
>
> You can try to partition the indexes and tables. By doing so you can split
> the load evenly across the datafiles. Just remember the golden rule: Don't
> put the table, and it's index on the same drive.
>
> Nemniss
>
> Mirza Mohsin Beg <mbeg_at_netearnings.com> wrote in message
> news:37E8769B.3262FA8A_at_netearnings.com...
> >
> > Hi,
> >
> > I am trying to create several indexes in a single tablespace which has
> > several datafiles over different several external drives.
> >
> > Is there any specific way to make Oracle 8.0.5 create specific objects
> > (ie the indexes) in specific datafiles, than having a different
> > tablespace per index.
> >
> > Thanks,
> >
> > -M
> > ps: please email me directly also.
> >
Received on Wed Sep 22 1999 - 07:01:18 CDT
