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]
