Re: [Firebird-devel] Odp: Some aspects of the optimizer hints

2014-01-08 Thread Kjell Rilbe
Den 2014-01-08 09:32 skrev Dmitry Yemanov såhär: > 08.01.2014 12:15, Kjell Rilbe wrote: > >> That said, I'd vote against "plan for/hint" if the plan clause in its >> current use is or is soon going to be deprecated. So, what are the plans >> for the plan clause? > Explicit planning is still used by

Re: [Firebird-devel] Odp: Some aspects of the optimizer hints

2014-01-08 Thread Dmitry Yemanov
08.01.2014 12:15, Kjell Rilbe wrote: > That said, I'd vote against "plan for/hint" if the plan clause in its > current use is or is soon going to be deprecated. So, what are the plans > for the plan clause? Explicit planning is still used by some customers, so it cannot be deprecated. But it's n

Re: [Firebird-devel] Odp: Some aspects of the optimizer hints

2014-01-08 Thread Kjell Rilbe
Den 2014-01-08 08:22 skrev Dmitry Yemanov såhär: > 08.01.2014 10:30, liviusliv...@poczta.onet.pl wrote: > >> Why plan can not by extended for hint purposes? > It can, the question is whether it should. > >> This is natural placefor FB users to tell optimizer >> the better way of query execution. >

Re: [Firebird-devel] Odp: Some aspects of the optimizer hints

2014-01-07 Thread Dmitry Yemanov
08.01.2014 10:30, liviusliv...@poczta.onet.pl wrote: > Why plan can not by extended for hint purposes? It can, the question is whether it should. > This is natural placefor FB users to tell optimizer > the better way of query execution. Personally, I see an important difference between planning

[Firebird-devel] Odp: Some aspects of the optimizer hints

2014-01-07 Thread liviusliv...@poczta.onet.pl
>>I'd suggest to let the legacy PLAN resting in piece. It's already misses many >>optimizer features and will outdate more and more with years. Hi, Dmitry Why plan can not by extended for hint purposes? This is natural place for FB users to tell optimizer the better way of query execution. Thi