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.


Dmitry