all foreign key should have index?
From: Murtuja <Murtuja.Khokhar_at_gmail.com>
Date: 30 Jan 2006 05:51:41 -0800
Message-ID: <1138629101.268470.215840_at_o13g2000cwo.googlegroups.com>
Is it necessary that all foreign key should have index?
Date: 30 Jan 2006 05:51:41 -0800
Message-ID: <1138629101.268470.215840_at_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 - 14:51:41 CET