RE: Using indexes

2009-10-03 Thread C N Davies
, 3 October 2009 6:50 PM To: 'users@openjpa.apache.org' Subject: Using indexes Is there any way I can force OpenJPA 1.2.1 to use a specific index when querying? My field is indexed but key lookups are lightning fast whereas if I query to search on a non-key field which is indexe

Using indexes

2009-10-03 Thread C N Davies
Is there any way I can force OpenJPA 1.2.1 to use a specific index when querying? My field is indexed but key lookups are lightning fast whereas if I query to search on a non-key field which is indexed it takes forever, so I am assuming that it is not using the index. It may be an issue with the