particullary filter
data then it should be prefered :)
regards,
Karol Bieniaszewski
From: 'livius' liviusliv...@poczta.onet.pl [firebird-support]
Sent: Saturday, February 18, 2017 8:30 PM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Re: Firebird 3 execution plan
>
16.02.2017 21:20, liviuslivius wrote:
>
> can this plan be selected by Firebird in somehow automatically without
> going to left join or +0 solution?
In this particular case, I'm afraid you don't have any other choice. But
I will think a little bit more, maybe some clever idea will come.
Hi Dmitry,
current snapshot: WI-V3.0.2.32691 Firebird 3.0
CREATE UNIQUE DESCENDING INDEX IXDU_SENSOR_DATA__ID ON SENSOR_DATA (ID);
ID bigint
selectivity
PK_SENSOR ASC ID 0.25
UK_SENSOR__SENSOR_UID ASC SENSOR_UID 0.25
FK_SENSOR_DATA__SENSOR ASC ID_SENSOR 0.25
16.02.2017 21:20, liviuslivius wrote:
>
> Firebird3
There's no such a version.
> plan is "expected"
> PLAN JOIN (SD ORDER IXDU_SENSOR_DATA__ID, S INDEX (PK_SENSOR))
What's definition of IXDU_SENSOR_DATA__ID?
Dmitry
