so if you don't turn fastfk on, is the index slow? what is the significance of not having it on. ----- Original Message ----- From: "Tom Grimshaw" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, April 08, 2002 11:37 PM Subject: Re: Please explain foreign keys, index
> G'day Bernie, > > At 22:50 07/04/02 -0400, you wrote: > >the syntax for ALTER shows that you can select foreign index or foreign > >keys. So what is the difference > > When you click on the INDEX in the syntax it displays: > > FOREIGN INDEX > With the FASTFK setting on, creates a > foreign key that has an index using > row pointers for data retrieval on selected columns. > > I recall reading about using fast foreign keys some years > ago but have never used FASTFK so we better ask those who > have used it... > > (This would be a good time for someone to chime in........) > > >----- 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/ > > Warmest regards, > > > Tom Grimshaw > coy: Just For You Software > tel: 612 9552 3311 > fax: 612 9566 2164 > mobile: 0414 675 903 > > post: PO Box 470 Glebe NSW 2037 Australia > street: 3/66 Wentworth Park Rd Glebe NSW 2037 > > email: [EMAIL PROTECTED] > web: www.just4usoftware.com.au > > This email and any files transmitted with it are confidential to the > intended recipient and may be privileged. If you have received this email > inadvertently or you are not the intended recipient, you may not > disseminate, distribute, copy or in any way rely on it. Further, you should > notify the sender immediately and delete the email from your computer. > Whilst we have taken precautions to alert us to the presence of computer > viruses, we cannot guarantee that this email and any files transmitted with > it are free from such viruses. > > ================================================ > 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/ ================================================ 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/
