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: Hans Forbrich <forbrich_at_telusplanet.net>
Date: Mon, 06 Aug 2001 01:56:39 GMT
Message-ID: <3B6DFD00.DFC1C067@telusplanet.net>

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

Original text of this message

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