added indexes for minor tables