Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: creating index
One of the primary reasons for indexes is to speed up the search for the records in the table. If you put the index into the same tablespace as the table, then you permit a potential conflict - speed up the search for the record, but slow down the retrieval of the record itself because the disk head is bouncing around the index.
This is theoretical - actual mileage may vary and could be checked out by using tools such as Oracle's Tuning Pack. Always worth benchmarking in your own environment.
/Hans
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
Received on Sun Aug 05 2001 - 20:56:39 CDT