db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Kristian Waagan <Kristian.Waa...@Sun.COM>
Subject Re: Indexes on functions
Date Tue, 16 Feb 2010 10:10:37 GMT
On 16.02.10 10:54, Vrin26 wrote:
> Hello,
>
> Is there a way to create index on functions in Derby?
> I have a query as 'select emp_name, emp_addrs.....from empTable where
> UPPER(name) like ' SA%';
> In Derby docs it's mentioned that indexes can be created only on column
> names.
> How can we achieve functional indexing in Derby?
>    

Hello,

Would generated columns [1] satisfy your needs?

There is also some information recorded in DERBY-455 [2], but the 
proposed solution hasn't been implemented.


Regards,
-- 
Kristian

[1] http://blogs.sun.com/kah/entry/derby_10_5_preview_generated (see 
also the reference manual)
[2] https://issues.apache.org/jira/browse/DERBY-455

> Thanks.
>    


Mime
View raw message