Oracle FAQ

Your Portal to the Oracle Knowledge Grid

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

Home -> Community -> Usenet -> comp.databases.theory -> Re: all foreign key should have index?

Re: all foreign key should have index?

From: -CELKO- <jcelko212_at_earthlink.net>
Date: 30 Jan 2006 21:57:39 -0800
Message-ID: <1138687059.234890.22280@g47g2000cwa.googlegroups.com>

>> Is it necessary that all foreign key should have index? <<

No. But better SQL products construct a "PK=FK" index under the covers for you. Received on Mon Jan 30 2006 - 23:57:39 CST

This message: [ Message body ]
Next message: x: "Re: Reminder, blatant ad"
Previous message: dawn: "Re: 3vl 2vl and NULL"
In reply to: Murtuja: "all foreign key should have index?"
Next in thread: Tony Rogerson: "Re: all foreign key should have index?"
Reply: Tony Rogerson: "Re: all foreign key should have 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