This might help for the latest OpenJpa (it should have partial 2.1 compatibility) https://stackoverflow.com/a/22658951/3571661
On Wed, 12 Dec 2018 at 01:17, Matthew Broadhead <matthew.broadh...@nbmlaw.co.uk.invalid> wrote: > recently had an application running slowly and had to manually add an > index. but openjpa seemed to create all the other indexes automatically. > my structure was like > Bill > has a collection of > BillMoney > has a collection of > BillSection > has a collection of > BillEntry > > BillMoney was automatically created with index I_BLLMONY_BILL which > related to the Bill id > BillSection was automatically created with index I_BLLSCTN_BILLMONEY > which related to the BillMoney section > But BillEntry did not have an index. > > BillEntry was a pre existing table so could that have something to do > with it? is there any way to force indexes to be created? > -- WBR Maxim aka solomax