| Subject | Re: [firebird-support] Re: Firebird 3 execution plan |
|---|---|
| Author | liviuslivius |
| Post date | 2017-02-16T19:12:41Z |
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
__._