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 -> Foreign key constraint removes need for index?

Foreign key constraint removes need for index?

From: <johnhurt_at_gmail.com>
Date: 13 Sep 2006 14:26:36 -0700
Message-ID: <1158182796.761952.211530@m73g2000cwd.googlegroups.com>

If column A has a foreign key constraint with a parent table, then do I need to explicitly add an index on column A for performance in queries? Received on Wed Sep 13 2006 - 16:26:36 CDT

This message: [ Message body ]
Next message: sporb: "Re: Using java to move large objects/data over db link?"
Previous message: LJ: "Re: ORA-01654 Error Handling"
Next in thread: fitzjarrell_at_cox.net: "Re: Foreign key constraint removes need for index?"
Reply: fitzjarrell_at_cox.net: "Re: Foreign key constraint removes need for index?"
Reply: frank.van.bortel_at_gmail.com: "Re: Foreign key constraint removes need for index?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

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