Hi,
I have a question about EQL and performance issues using Glassfish and Derby DB.
We have two Entity Beans (A and B). Bean A has a one-to-many relationship to Bean B.
Bean B has additional to its primary key two attributes : 'name' and 'value'
To select a subset ob Bean A I use the following EQL Statement:
SELECT a from A AS a
JOIN a.bList AS t
WHERE t.name = 'type'
AND t.value = 'project'
My Question is: can I increase performance if I add an Index to b.name and b.value manually? And is this possible using Derby DB?
Thanks for help
Ralph
[Message sent by forum member 'rsoika' (rsoika)]
http://forums.java.net/jive/thread.jspa?messageID=280437