Re: creating index

Thnx, I would create few indexes for my tables.

"Daniel A. Morgan" <Daniel.Morgan_at_attws.com> wrote in message news:3B45DA0D.E4240B68_at_attws.com...
> hartono_nugroho_at_attglobal.net wrote:
>
> > Hi all,
> >
> > Should I create index in its own table space or can I put it in it's
 table
> > tablespace?
> > I would create index mostly on the foreign key column.
> >
> > Thanks for the advice.
> > Ari
>
> Rule of thumb is tables in one tablespace, indexes in another. It would be
 a
> very rare situation where there would be a need to built a tablespace to
 hold
> a single index.
>
> Daniel A. Morgan
>
Received on Sat Jul 21 2001 - 16:31:20 CDT