>
> 11.09.2016 10:29, 'Djordje Radovanovic' [email protected] [firebird-support]
> wrote:
> > This time instead of 10000 reads of orders and 10000 reads of partners I
> > received exactly
> > what I was asking for.
>
Hi,
i do not know what server do you use but if i run simple query on FB3
select
o.*
from
partners p
inner join orders o ON p.partid = o.partid
WHERE
p.country = 'Spain';
on non propagated with data tables, plan is:
PLAN JOIN (P INDEX (PARTNERS_IDX1), O INDEX (FK_ORDERS_PARTNERS))
but if i fill tables with test data and UPDATE INDEX STATISTICS
i got plan
PLAN JOIN (P INDEX (PARTNERS_IDX1), O INDEX (FK_ORDERS_PARTNERS))
then i suppose your real problem is your index statistics or selectivity of
some values in joined fields
regards,
karol Bieniaszewski
