those interested in this or any other feature/bug fix but don't have
the ability to implement it (scratch their own itch) themselves may want
to vote for it in JIRA. The JIRA entry is DERBY-455.
I think this feature could provide a lot of interesting applications
which we have not even thought of, as Dan has shown with native
sort order support. Even if national sort order is implemented,
having the ability in a single db to provide multiple efficient
user defined sort orders seems interesting.
Satheesh Bandaram wrote:
Derby doesn't allow creating functional indexes.... Rick started a
discussion about how to provide that functionality about 6 months ago. I
thought an agreement was reached in the community and I was under the
impression he is working on it, though I haven't seen any follow ups.
Rick may know more.
Satheesh
Edson Carlos Ericksson Richter wrote:
Probably, the most important are that using large tables with "order
by SOME_FUNCTION(some_col)" could not be optimized unless you could
index as "create index IDX_SOMETHING on MY_TABLE
(SOME_FUNCTION(some_col))" too... Could Derby create and use indexes
based on functions computing?
I think using national character datatypes will give that kind of
optimization, don't?
Best regards,
Edson Richter
