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 >
