I did log an enhancement request but I'm not working on it right now.
Regards,
-Rick
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
