Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: creating index

Re: creating index

From: Daniel A. Morgan <Daniel.Morgan_at_attws.com>
Date: Fri, 06 Jul 2001 08:32:29 -0700
Message-ID: <3B45DA0D.E4240B68@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 Fri Jul 06 2001 - 10:32:29 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US