db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Satheesh Bandaram <sathe...@Sourcery.Org>
Subject Re: Language based ordering is possible in Derby
Date Thu, 03 Nov 2005 15:17:56 GMT
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.


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

View raw message