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 -> all foreign key should have index?

all foreign key should have index?

From: Murtuja <Murtuja.Khokhar_at_gmail.com>
Date: 30 Jan 2006 05:45:23 -0800
Message-ID: <1138628723.210312.190750@o13g2000cwo.googlegroups.com> 





Is it necessary that all foreign key should have index?



SELECT * FROM user_constraints WHERE CONSTRAINT_TYPE = 'R'
AND INDEX_NAME IS NOT  NULL


Above query does not return any row in my database.Is it bad?
Received on Mon Jan 30 2006 - 07:45:23 CST












Original text of this message













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