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 -> Index no needed in child table in Oracle9i?

Index no needed in child table in Oracle9i?

From: Anonymous <mail_for_deja_at_yahoo.com>
Date: 1 Jan 2002 23:13:34 -0800
Message-ID: <8ee5d7c9.0201012313.645968e0@posting.google.com> 





Hi all,



    I remember in Oracle8i, I need to create index on child table (to
prevent entire child table locked by parent table DML). I heard that
in Oracle9i, no need to create index on those columns. Is that true?
And how Oracle resolves this locking problem in Oracle9i?



Thanks,


David
Received on Wed Jan 02 2002 - 01:13:34 CST












Original text of this message













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