--- In firebird-support@yahoogroups.com, Dmitry Yemanov <dimitr@...> wrote:

>
> 04.12.2012 19:50, rick_roen wrote:
> >
> > The DML for the View is not really relevant, I only mentioned it to
> > explain why I am trying to use a Plan at all since I could easily use an
> > "order by" statement, which does work in the stand-alone Select.
>
> ORDER BY works in views as well, unless you're still with FB 1.x.
>
> > I would like to know for future reference why I could not specify the
> > Plan for this Select. As I said, I have never tried to use one
> > explicitly, so I must be missing something simple.
>
> Plan must match the select expression, period. Without an ORDER BY
> clause, an ORDER plan makes zero sense and hence rejected.

That makes sense Dmitry. Thanks.

> Dmitry
>