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?