the syntax for ALTER shows that you can select foreign index or foreign keys. So what is the difference
----- Original Message ----- From: "Tom Grimshaw" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, April 08, 2002 11:25 AM Subject: Re: Please explain foreign keys, index > G'day Bernie, > > What is the definition of a foreign index? > > At 16:00 07/04/02 -0400, you wrote: > >what is diff between foreign key and foreign index? > >If I create a foreign index is that column indexed for look ups in that > >table. If I create a foreign key do I still have to build an index for > >look up in that table ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/
