Karol,
> CREATE INDEX IXA_WPLATA__KONTRAHENT__PK ON WPLATA
> (WPLATA_KONTRAHENT_ID,DYR_ID);
> statistics both 0.000007
> CONSTRAINT WPLATA_PK PRIMARY KEY
> (DYR_ID)
> statistics both 0.000000
Please provide the result for:
select rdb$index_name, rdb$field_name, rdb$statistics
from rdb$index_segments
where rdb$index_name in (‘IXA_WPLATA__KONTRAHENT__PK’, ‘WPLATA_PK’)
--------------------------------------------------------------------------
FB2.5
PLAN JOIN (JOIN (JOIN (SORT (JOIN (W INDEX (WARUNKI_FK1), U NATURAL)), UM INDEX
(UMOWA_PK)), RD INDEX (RODZAJ_DZIAL_PK)), OJ INDEX (OPLATAJ_PK))
FB3.0
PLAN JOIN (JOIN (JOIN (JOIN (W ORDER WARUNKI_PK, U NATURAL), UM INDEX
(UMOWA_PK)), RD INDEX (RODZAJ_DZIAL_PK)), OJ INDEX (OPLATAJ_PK))
And what are the timings?
Please also provide number of page fetches for all the queries.
Dmitry
------------------------------------------------------------------------------
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel