Hi Ateesh,
Optimizer hint support was added to Derby 10.2 as part of jira DERBY-573 : Provide support for optimizer overrides in Derby.
If you think you have come across some Derby optimization issue with your particular scenario, you should probably send more info on it to the Derby community and someone might be able to take a look to see if there is a real bug involved here.

On 7/7/06, Ateesh_Verma@rapid7.com <Ateesh_Verma@rapid7.com> wrote:

Is there a way to add hints to derby optimizer ?

For example, I have a query that is supposed to use an index. The optimizer mostly uses
the index but sometimes decides to do a table scan!

I have tried different transformations of the query but I see the same inconsistent behavior.

Any suggestions?