Tom -
I think all the "chimers" are working on deadline for the conference ... I
haven't used the FASTFK myself, or I'd be happy to chime in!
With that said, here is the explanation in the HTML Help file on the SET
FASTFK option:
This setting, when on, permits R:BASE to operate a foreign key index using a
condensed index for maintaining that foreign key. If the foreign key is not
used for retrieving data or linking columns, a complete index is unnecessary
and actually inhibits speed. When set to on, R:BASE creates a condensed
index for any existing foreign keys.
To switch to condensed indexes on existing foreign keys, you need to run a
PACK, PACK KEYS, or RELOAD command with FASTFK on; these actions cause
R:BASE to rebuild the database with condensed foreign key indexes.
Keep in mind, however, that you might need complete indexes on foreign keys
where such indexes are needed for retrieving data. Retaining a separate
index on columns used in foreign keys that link tables is preferred. Indexes
are also needed on foreign keys that you use for selecting column values;
therefore, use the CREATE INDEX command to explicitly create indexes for
columns used in foreign keys in a database where FASTFK is set on.
The command SHOW FASTFK displays the FASTFK state and whether FASTFK is
operational in the current database. For example:
SHOW FASTFK
(FASTFK ) ON Use fast Foreign Key (FK) structures on rebuild.
OFF FASTFK setting for current database
Once you rebuild the keys in a database with the FASTFK setting on, SHOW
FASTFK displays the following:
SHOW FASTFK
(FASTFK ) ON Use fast Foreign Key (FK) structures on rebuild
ON FASTFK setting for current database
Sami
----- Original Message -----
From: "Tom Grimshaw" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, April 08, 2002 10: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/
