Re: separate data/inidex

From: D.Y. <dyou98_at_aol.com>
Date: 29 Apr 2002 11:37:34 -0700
Message-ID: <f369a0eb.0204291037.18f0bc9f@posting.google.com>

ganesh_at_gtfs-gulf.com (Ganesh Raja) wrote in message news:<a8aed4.0204290646.4743b954_at_posting.google.com>...
> gitaya_at_hotmail.com (MauMau) wrote in message news:<1391a36e.0204210411.c3a275_at_posting.google.com>...
> > "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)
> >
> > No prob just rebuild your indexes using a predefined tablespace
> > good idea to rebuild from time to time.
>
> Here goes Another Myth ... Can U tell us why u need to Rebuild teh
> Indexes from Time to Time...

to reduce index fragmentation (not tablespace fragmentation), and possibly reduce the depth of the B tree, so that your application won't have to read half empty blocks on index scans. It's a good idea, though, to set a nonzero pctfree to avoid excesive index block splits on inserts and updates.

>
> Regards,
> Ganesh R
Received on Mon Apr 29 2002 - 13:37:34 CDT