At 10:45 AM 9/1/2005, Alan Wolfe wrote:
do foreign keys help speed lookups up at all?
Alan,
The simple answer is no.
In a True-Relational Database like R:BASE, a FOREIGN KEY
is defined for data constraint that works in conjunction
with PRIMARY KEY to enforce referential integrity among
specified tables. It is a relationship or link between
two tables which ensures that the data stored in a
database is consistent.
Proper INDEXing of matching columns will certainly speed
lookups.
FOREIGN KEYs are also useful when a CASCADE option is
added to a table with PRIMARY KEY. This option maintains
the Primary/Foreign key relationships automatically. For
example, if you either update or delete a Primary Key
value from this table, the corresponding Foreign Key
values are updated or deleted automatically.
Hope that helps to understand the Foreign Keys!
Very Best R:egards,
Razzak.
--- RBASE-L
================================================
TO POST A MESSAGE TO ALL MEMBERS:
Send a plain text email to [email protected]
(Don't use any of these words as your Subject:
INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH,
REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP)
================================================
TO SEE MESSAGE POSTING GUIDELINES:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: INTRO
================================================
TO UNSUBSCRIBE:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: UNSUBSCRIBE
================================================
TO SEARCH ARCHIVES:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: SEARCH-n
(where n is the number of days). In the message body,
place any
text to search for.
================================================
