Re: [Firebird-devel] Explained plan "Access By ID"

2015-03-09 Thread James Starkey
A DBKEY is a concatenation of one or more 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 imple

Re: [Firebird-devel] Explained plan "Access By ID"

2015-03-09 Thread Dmitry Yemanov
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

[Firebird-devel] Explained plan "Access By ID"

2015-03-09 Thread liviuslivius
Hi,   what is "Access By ID" in explained plan? Why "ID"? -> Filter                             -> Table "ZLEC_FAKT" as "ZF" Access By ID     regards, Karol Bieniaszewski-- Dive into the World of Parallel Programming The Go