Subject | Re: [firebird-support] Index cannot be used in the specified plan |
---|---|
Author | Ted Miglautsch |
Post date | 2012-12-04T14:14:05Z |
> Select G.GERM from Germination GYou might try
> PLAN (G ORDER I_GERMINATION_DATE_DESC)
Select G.GERM from Germination G
PLAN (G ORDER I_GERMINATION_DATE_DESC DESC)
> Select G.GERM from Germination G order by G.GERM_DATE DescIf you look closely at your example you will see there is no "_" between
the GERM_DATE and Desc.