Re: Indexes

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Mon, 22 Nov 1999 16:54:22 +0800
Message-ID: <383904BE.7B8B@yahoo.com>

Sybrand Bakker wrote:
>
> 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)
> >
> >

although from 7.3 upwards, oracle did make some good inroads into this so that the locking is not as severe as it used to be... --

---

Connor McDonald
"These views mine, no-one elses etc etc" connor_mcdonald_at_yahoo.com

"Some days you're the pigeon, and some days you're the statue." Received on Mon Nov 22 1999 - 02:54:22 CST