db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Vrin26 <divi.markapu...@in.ibm.com>
Subject Indexes on functions
Date Tue, 16 Feb 2010 09:54:54 GMT

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?

Thanks.
-- 
View this message in context: http://old.nabble.com/Indexes-on-functions-tp27605852p27605852.html
Sent from the Apache Derby Users mailing list archive at Nabble.com.


Mime
View raw message