kokok_kokok wrote:

>
> FB selects the optimal plan for the above statement, using OrderDate
> as index.
>
> ...
>
> In the above case, FB get a suboptimal plan, using a natural plan
> instead of the OrderDate index.

Please provide exact plans for both these queries, not some wording.


Dmitry