db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Rick Hillegas <Richard.Hille...@Sun.COM>
Subject Re: Language based ordering is possible in Derby
Date Thu, 03 Nov 2005 15:55:25 GMT
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
>>
>>    
>>
>
>  
>


Mime
View raw message