db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jan Hlavatý <hla...@code.cz>
Subject Re: Hints
Date Sat, 16 Oct 2004 16:10:56 GMT
>>>Given that optimizer hints are useful (even necessary), how could one
>>>support them in a "standard" way? I suppose they could be hidden in
>>>comments, although building the support for this isn't simple

What is forcing you to use hints?
Query planner should use that index automatically.
It it does not, it did a poor job. It would be good to know why and fix it.
Having SQL database with declarative query syntax without need to worry
about how it will be executed is very important for usability.

View raw message