Re: [firebird-support] Re: Firebird 3 execution plan

[liviuslivius liviusliv...@poczta.onet.pl [firebird-support]]

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.250000
 
UK_SENSOR__SENSOR_UID ASC SENSOR_UID 0.250000
FK_SENSOR_DATA__SENSOR ASC ID_SENSOR 0.250000 
IXDU_SENSOR_DATA__ID DESC ID 0.000002 
PK_SENSOR_DATA ASC ID 0.000002
 
regards,
Karol Bieniaszewski
 
 
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
__._