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.
