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