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-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 not

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 some

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