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_DYREKCJA" Full Scan
-> Bitmap Or
-> Bitmap
-> Index "PK_DYREKCJA" Unique Scan
-> Bitmap
-> Index "PK_DYREKCJA" Unique Scan
-> Filter
-> Table "INSPEKTORAT" as "I" Access By ID
-> Bitmap
-> Index "FK_INSPEKTORAT__DYREKCJA" Range Scan (full match)
Ok, i see that between
Table "DYREKCJA" as "D" Access By ID
and
Index "PK_DYREKCJA" Full Scan
there is no "BITMAP", but can this be improved to see this more explicitly?
Look how this looks like for legacy plan
PLAN JOIN (D ORDER PK_DYREKCJA INDEX (PK_DYREKCJA, PK_DYREKCJA), I INDEX
(FK_INSPEKTORAT__DYREKCJA))
you see this explicitly that we have "ORDER" by index
What do you think?
regards,
Karol Bieniaszewski
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
