Thanks Ted and Svein,

The Plan that Ted suggested did not work either. The "DESC" at the end was not recognized.

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.

I did a work-around which puts this Germination Select into an SP where I can set the order to DESC, so the immediate problem is solved.

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.

-Rick