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
