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?

Reply via email to