Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: creating index
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