db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ateesh_Ve...@rapid7.com
Subject Derby optimizer hints?
Date Sat, 08 Jul 2006 04:06:23 GMT
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?

Thanks,
Ateesh
Mime
View raw message