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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Indexes

Re: Indexes

From: Sybrand Bakker <postmaster_at_sybrandb.demon.nl>
Date: Mon, 22 Nov 1999 09:03:15 +0100
Message-ID: <943257866.17066.0.pluto.d4ee154e@news.demon.nl>


Indexes on
1) all primary keys, of course
2) all foreign keys. This might not be benificial though when the table is small. Background for this is in constraint checking Oracle will lock the table if the index is lacking.

Finally, DO create them in a separate tablespace.

Hth,

--
Sybrand Bakker, Oracle DBA
Cherk <andrija.cerkez_at_lijanovici.com> wrote in message news:81at0b$cb0$1_at_as102.tel.hr...
> Hi,
>
> Is there a general rule for creating indexes.
>
> (On which collumn, etc.... )
>
> --------------------------------------------------------------------------
--
> --------------
> I have the simplest tastes. I am always satisfied with the best.
> --------------------------------------------------------------------------
--
> --------------
> Cherk (andrija.cerkez_at_lijanovici.com), Siroki Brijeg, Croatia
> Cherk's home page (http://www.angelfire.com/co/Cherk)
>
>
Received on Mon Nov 22 1999 - 02:03:15 CST

Original text of this message

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