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
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
Thanks you Dmitry
Regards,
Karol Bieniaszewski
- Reply message -
Od: "Dmitry Yemanov"
Do: "For discussion among Firebird Developers"
Temat: [Firebird-devel] Explained plan "Access By ID"
Data: pon., mar 9, 2015 12:21
09.03.2015 14:13, liviuslivius wrote:
>
> what is "Access By ID" in
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
Hi,
what is the difference between
Index "ROZLICZENIE_FK1" Range Scan (lower bound: 1/1, upper bound: 1/1)
Index "RODZAJ_DZIAL_FK" Range Scan (partial match: 1/2)
i suppose partial match is about fields used in compound index but what is here
lower/upper bound?
regards,
Karol Bieniaszewsk
09.03.2015 17:06, liviuslivius wrote:
>
> what is the difference between
> Index "ROZLICZENIE_FK1" Range Scan (lower bound: 1/1, upper bound: 1/1)
When you see "lower/upper bound: N/M", this is a "less/greater/between"
scan. Each boundary condition may use N of M segments.
> Index "RODZAJ_DZIAL_
>
> what is the difference between
> Index "ROZLICZENIE_FK1" Range Scan (lower bound: 1/1, upper bound: 1/1)
>>When you see "lower/upper bound: N/M", this is a "less/greater/between"
>>scan. Each boundary condition may use N of M segments.
Thanks. Now this is clear :)
regards,
Karol Bieniaszews
Quickly tested it, built w/o problems in Xcode! Thanks!
On Sunday, March 8, 2015 2:24 PM, Egor Pugin wrote:
Hi,
Should be fixed now.
Update trunk to the latest revision and try to build it.
Please note that cmake build is still an experimental feature.
On 8 March 2015 at 14:59, Nil
On 08-03-2015 12:05, liviusliv...@poczta.onet.pl wrote:
>
> With that changes all work
>
Please try the current files without modifications.
> PS> is it possible to specify user and pass without storing it in system
> vars - which is not secure?
>
You could build DPB as before. This is a pi
