Re: separate data/inidex

Mister Rogers,

I can't believe you said this.

Tablespaces containing tables, and tablespaces containing indices corresponding to them, would be like locating matter and antimatter on the same spindle.

In RAID environments, I do not even like them sharing the same controller; failing that, certainly not sharing the same RAID ranks.

How do you arrive at this astonishing (to me at least) notion?

RSH.
"Howard J. Rogers" <dba_at_hjrdba.com> wrote in message news:a9ov52$kjn$1_at_lust.ihug.co.nz...
> There is precisely zero physical reason for separating indexes and tables,
> at least in routine database configurations. No performance gain arises if
> you do. There are real *management* issues (tables *need* backing up,
> indexes don't). And the rebuild command is fine to move the indexes
> somewhere else if you decide to do it; but then the 'alter table X move'
> command will do much the same by shunting the tables off somewhere new,
too.
>
> Regards
> HJR
>
> "Troy Meyerink" <meyerink_at_usgs.gov> wrote in message
> news:Gus70n.CA3_at_igsrsparc2.er.usgs.gov...
> > You need to create an index tablespace and then move the existing
indexes
> by
> > issuing an
> > 'alter index rebuild' statement.
> >
> > Troy Meyerink
> > Oracle DBA
> > Raytheon
> >
> >
> > "Titi" <thierry.constant2_at_wanadoo.fr> wrote in message
> > news:3cbf2607$0$15182$626a54ce_at_news.free.fr...
> > > Hi,
> > >
> > > For a user, I have data and index in one tablespace.
> > > I want to separate data and index ( good idea ??)
> > >
> > > How can do that ???
> > >
> > > Thanks in advance ...
> > > ( oracle 8.1.7)
> > >
> > >
> >
> >
>
>
Received on Sun Apr 21 2002 - 01:46:10 CDT