Re: [Firebird-devel] FB3 - Explained plan ordered result

2019-04-24 Thread liviuslivius
> Would something like this be better: > -> Index "PK_DYREKCJA" Full Scan (ordered by < field name(s) >) > > ? > Mayby changing "Full Scan" name here is better? To e.g. "Ordered Retrival" or Full Scan (ordered) or Order Index "PK_DYREKCJA" Full Scan >>> If so, should it be printed for looku

Re: [Firebird-devel] FB3 - Explained plan ordered result

2019-04-24 Thread Dmitry Yemanov
24.04.2019 10:03, liviuslivius wrote: i have looked at this simple explained plan and i see that from it i cannot read simply that result set is sorted and retrived by index. Select Expression     -> Nested Loop Join (inner)         -> Filter             -> Table "DYREKCJA" as "D" Access By

[Firebird-devel] FB3 - Explained plan ordered result

2019-04-24 Thread liviuslivius
Hi   i have looked at this simple explained plan and i see that from it i cannot read simply that result set is sorted and retrived by index.   Select Expression     -> Nested Loop Join (inner)         -> Filter             -> Table "DYREKCJA" as "D" Access By ID                 -> Index "PK_DYREK