Hi Dmitry,
if plan can go in direction like this
PLAN JOIN (SD ORDER IXDU_SENSOR_DATA__ID INDEX (FK_SENSOR_DATA__SENSOR), S
INDEX (PK_SENSOR))
then this is totally optimal plan for case with First and index used in the
same time
For “First” ORDER should have priority and if index can 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
>>I will think a little bit more, maybe some clever idea will come.
fingers crossed
regards,
Karol Bieniaszewski
From: Dmitry Yemanov dim...@users.sourceforge.net [firebird-support]
Sent: Friday, February 17, 2017 7:38 PM
To: firebird-support@yahoogroups.com
Subject: [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.
Dmitry
---
Ta wiadomość została sprawdzona na obecność wirusów przez oprogramowanie
antywirusowe Avast.
https://www.avast.com/antivirus
[Non-text portions of this message have been removed]
