A DBKEY is a concatenation of one or more <relation id, record number>
pairs.
Has anyone considered a global replace of "relation" by "table"? Relation
is not only archaic but mathematically incorrect. In Codd's model,
relations were sets and consequently could not have duplicate rows. No
"relational" database every implemented these semantics, giving at most lip
service to Codd and the relational model.
The guy who wrote the original code obviously wasn't paying close
attention, which is strange as he has a degree in mathematics, knew what
the words meant, and should have known better with regards to terminology.
We're just lucky he got the semantics right.
On Monday, March 9, 2015, Dmitry Yemanov <firebi...@yandex.ru> wrote:
> 09.03.2015 14:13, liviuslivius wrote:
> >
> > what is "Access By ID" in explained plan? Why "ID"?
> > -> Filter
> > -> Table "ZLEC_FAKT" as "ZF" Access By ID
>
> ID = internal record identifier (number). Better publicly known as
> DBKEY, although DBKEY is actually a wider term, as it includes also a
> relation ID.
>
>
> Dmitry
>
>
>
> ------------------------------------------------------------------------------
> Dive into the World of Parallel Programming The Go Parallel Website,
> sponsored
> by Intel and developed in partnership with Slashdot Media, is your hub for
> all
> things parallel software development, from weekly thought leadership blogs
> to
> news, videos, case studies, tutorials and more. Take a look and join the
> conversation now. http://goparallel.sourceforge.net/
> Firebird-Devel mailing list, web interface at
> https://lists.sourceforge.net/lists/listinfo/firebird-devel
>
--
Jim Starkey
------------------------------------------------------------------------------
Dive into the World of Parallel Programming The Go Parallel Website, sponsored
by Intel and developed in partnership with Slashdot Media, is your hub for all
things parallel software development, from weekly thought leadership blogs to
news, videos, case studies, tutorials and more. Take a look and join the
conversation now. http://goparallel.sourceforge.net/
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
