| Subject | Re: [firebird-support] Re: Firebird 3 execution plan |
|---|---|
| Author | livius |
| Post date | 2017-03-30T21:07:44Z |
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
Sent: Saturday, February 18, 2017 8:30 PM
Subject: Re: [firebird-support] Re: Firebird 3 execution
plan
come.>>I will think a little bit more, maybe some clever idea will
fingers crossed
regards,
Karol Bieniaszewski
From: Dmitry Yemanov dimitr@... [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:
>this plan be selected by Firebird in somehow automatically without
> can
> goingto 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]
 |
Wolny od wirusów. www.avast.com |