Subject | Re: [IBO] KeyLinks & Primary Keys |
---|---|
Author | Jason Wharton |
Post date | 2001-01-19T23:06:50Z |
Yes, that is right. It is what the index stores in it with the data value so
it knows where to reference the whole record it is holding a place in the
index for. Thus, using a DB_KEY is like having a slice of an index right in
the memory of your dataset. It works really great inside of stored
procedures to speed up single row updates because you make it so that a
searched edit to a row can avoid scanning index nodes.
FWIW,
Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com
it knows where to reference the whole record it is holding a place in the
index for. Thus, using a DB_KEY is like having a slice of an index right in
the memory of your dataset. It works really great inside of stored
procedures to speed up single row updates because you make it so that a
searched edit to a row can avoid scanning index nodes.
FWIW,
Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com
----- Original Message -----
From: <lester@...>
To: <IBObjects@egroups.com>
Sent: Friday, January 19, 2001 1:08 PM
Subject: Re: [IBO] KeyLinks & Primary Keys
> > It is unique for the life of a transaction
>
> So it is the internal record number of a particular generation of a
> record?
>
> --
> Lester Caine
> -----------------------------
> L.S.Caine Electronic Services
>
>
>