I have a desc index on table GERMINATION - I_GERMINATION_DATE_DESC.

When I run either one of these queries I get
"index I_GERMINATION_DATE_DESC cannot be used in the specified plan"

Select G.GERM from Germination G
PLAN (G ORDER I_GERMINATION_DATE_DESC)

Select G.GERM from Germination G
PLAN (G INDEX(I_GERMINATION_DATE_DESC))

The following is successful and in DBWorkbench shows Plan = "PLAN (G ORDER I_GERMINATION_DATE_DESC)"

Select G.GERM from Germination G order by G.GERM_DATE Desc

I am trying to use the PLAN because this Select is used as a subquery in a view where I cannot specify an order by.

I have never used Plan before, so what am I missing?

-Rick